Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “factory” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
factory1510834(None) 
factor11911451factor_
factors12912121factors
actor71116072_actor_
actorly1246412_actorly
actors81016762_actors
enactory1346142enactory
factoid1338692factoid
factored1436212factored
facture12108922facture
lactary1237842lactary
olfactory1743082olfactory
rectory123512732rectory
victory15326982victory
accord1178843_accord
acorn75616623_ac_orn
actuary1245613_actuary
amatory1238623amatory
armory114211473_armory
artery9911453_artery
astony9510523_astony
atomy107415193_a_tomy
atony87218853_a_tony
atopy106813393_a_topy
attorn6310793_attorn
backstory2045283backstory
battery124911813battery
cactoid12311033cactoid
calory11312843ca_lory
cantor85621523cantor_
cantors94620753cantors
captor104914603captor_
captors113914983captors
castor84418533castor_
castors94919443castors
cattery123811603cattery
cautery12349593cautery
coactor1139123coactor_
coactors1239473coactors
cofactor1545753cofactor_
cofactors1645933cofactors
cory96941513__c_ory
datary10310243da_tary
doctor938993doctor_
doctorly1443113doctorly
doctors1039993doctors
eatery95316353ea_tery
enactor938033enactor_
enactors1038453enactors
exactor1636623exactor_
exactors1737013exactors
facer105525053fac_er_
facers115519443fac_ers
facetely1643853facetely
fact97142543fact___
factful1536373factful
faction122613333faction
factions133013063factions
factious13239243factious
factoids1446243factoids
factorage1543343factorage
factorial1447023factorial
factories14810093factories
factoring1537523factoring
factorize2366893factorize
factotum1542443factotum
facts107021893fact__s
factual1246723factual
factures13129023factures
faculty1535573faculty
faery116015483fa__ery
faggotry1641673faggotry
faggoty1542863faggoty
fairy115318283fa__iry
faitour1034883faitour
faitours1134263faitours
fakery16509263fa_kery
falconry1642533falconry
falter94519053falter_
falters103916473falters
fantasy1336153fantasy
fantod102010033fanto_d
fantods11177623fantods
fantom112110803fanto_m
fantoms12189153fantoms
fanwort13310733fanwort
faster94625773faster_
fatly115716803fa_t_ly
fatter94523213fatter_
fattily13379463fattily
fatty115117413fa_t_ty
favor114712453fa_vor_
favors124211403fa_vors
feretory1447513feretory
fetor81214533f_etor_
fetors91014473f_etors
flackery20295243flackery
flattery14338293flattery
flavory1644743flavory
foetor939563foetor_
foetors1039763foetors
fractur12135563fractur_
fracture13147123fracture
fracturs13146313fracturs
fumatory1644923fumatory
fumitory1643893fumitory
functor1235203functor_
functors1335743functors
gantry103810113gant_ry
gator64416033ga_tor_
gators74115833ga_tors
hector113312653hector_
hectors123513263hectors
hickory1943903hickory
history1339423history
lactone9311393lactone
lactose969473lactose
lavatory1445693lavatory
lector83514983lector_
lectors93415763lectors
lictor83610853lictor_
lictors93212593lictors
locutory1344273locutory
martyry1533373martyry
mastery124214323mastery
mattery123810713mattery
natatory1146603natatory
nectary1246223nectary
oratory1039403oratory
paltry114910403palt_ry
pantry115014103pant_ry
pastor84817483pastor_
pastorly1345783pastorly
pastors94119003pastors
pastry114913033past_ry
placatory1645713placatory
raptor83912823raptor_
raptors94213353raptors
reactor93011653reactor_
reactors103212283reactors
rector84019753rector_
rectors93520523rectors
refectory1746023refectory
refractory18134773refractory
sartor6313883sartor_
sartors7314973sartors
satori6415843sa_tori
savory124310563sa_vory
sectary1238273sectary
sector83415933sector_
sectors93116453sectors
story86723033__story
succory1444643succory
tory75840543___tory
tractor9311333tractor_
tractors10312563tractors
vanitory1445733vanitory
vapory14398763va_pory
vector113212063vector_
vectors123212593vectors
victor113210673victor_
victors123311183victors
wastery134610993wastery
wastry12388773wast_ry
watery123914493wa_tery

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.453394461.4
2DLD Change Limit1340271657.20318607.1
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.71623158.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.