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 “confuses” 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.

244 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
confuses1331036(None) 
confuse1238851confuse_
confused1437031confused
confutes1339841confutes
contuses10413451contuses
bonuses94212952bon_uses
censuses10187542censuses
clonuses1057132clon_uses
coituses1039622coituses
coleuses1039722coleuses
concuss1138062concus_s
concusses1346342concusses
conduces13129782conduces
confess12399902confes_s
confesses1438622confesses
confides14310572confides
confines13315652confines
confluxes2143832confluxes
confute1239262confute_
confuted1437682confuted
confuter1338512confuter
confuters1437792confuters
conioses10313312conioses
conjures17119912conjures
consumes12310412consumes
contuse9311412contuse_
contused1138442contused
convulses1445502convulses
cornuses10310032cornuses
corpuses12310062corpuses
doofuses1244282doofuses
infuses102711872_infuses
nonuses73313862non_uses
onuses65616252_on_uses
tonuses73612192ton_uses
unconfuses1553212unconfuses
ankuses1148203_ankuses
anuses66218773_an_uses
boluses94113833bo_luses
bonfires1367383bonfires
bouses84931783bo__uses
cactuses1237933cactuses
calluses1039323calluses
campuses1437773campuses
canfuls1248423canfu_ls
cangues10611823cangu_es
canvases13349523canvases
carouses10614503carouses
caucuses1236783caucuses
causes88026473c__auses
cayuses12188403c_ayuses
censes83721803cen__ses
censures102211623censures
censused11184973censused
centeses1079443centeses
cereuses1049243cereuses
ceruses93716233c_eruses
cestuses1038083cestuses
chiauses1336483chiauses
choruses1339983choruses
chouses125117813c_houses
cinques1837333cinqu_es
circuses1238253circuses
cistuses1038283cistuses
citruses1037483citruses
clauses93813323c_lauses
codfishes1845643codfishes
coendures1245213coendures
coenures1048683coenures
coffees15329573co_ffees
coffles152610003co_ffles
cognises11610043cognises
cohunes1249713co_hunes
coiffes1546803coif_fes
coiffeuses1851683coiffeuses
coiffures1743213coiffures
coinsures1136723coinsures
colludes11279223colludes
colobuses1346133colobuses
colures9315143co_lures
combusts1445503combusts
communes143411243communes
commutes143011893commutes
composes145017113composes
computes143914553computes
concaves1538913concaves
concedes13311063concedes
conches144019813con_ches
conchies153214853conchies
concise11314473concise_
conciser12310243conciser
concisest1348253concisest
concludes1445143concludes
concourses1445353concourses
concurs11311473concu_rs
concussed1444753concussed
condenses12710133condenses
condoes104319203con_does
condoles113015803condoles
condones112817393condones
condores113315643condores
conduce12139233conduce_
conduced14136963conduced
conducer13127373conducer
conducers14136563conducers
conducts13118713conducts
conduits111210063conduits
condyles14277463condyles
conenoses1188903conenoses
cones76457423con___es
confabs1435393conf_abs
confects153110873confects
confer114018683conf__er
conferee13613733conferee
conferees14610623conferees
confers124120093conf_ers
confessed1546053confessed
confide13310203confide_
confided1537453confided
confider1438123confider
confiders1537483confiders
configures1644213configures
confine12315583confine_
confined14310403confined
confiner13311193confiner
confiners1439953confiners
confirms1536303confirms
confits122811423conf_its
confitures1545603confitures
conflates14311133conflates
conforms1538873conforms
confounds1544323confounds
confreres1448033confreres
confusedly1952123confusedly
confusing1537333confusing
confusion1446473confusion
confusions1546303confusions
congees103517923con_gees
conges94928173con__ges
congests113510383congests
congoes103617303con_goes
congress1138073congress
conies84338593con__ies
coniines10415363coniines
conines93827793con_ines
coniosis1048133coniosis
coniums11311863coniu_ms
conjure16109073conjure_
conjured18117903conjured
conjurer17117683conjurer
conjurers18126233conjurers
connives1339723connives
connotes10311453connotes
conquer1838623conqu_er
conquers1938223conquers
conquest1939553conquest
conquests2045363conquests
consists10310593consists
consoles103216153consoles
consuls92412313consu_ls
consults10219983consults
consume11510133consume_
consumed1337923consumed
consumer1238503consumer
consumers1337203consumers
contes84432913con__tes
contests103413383contests
conus76726533con_u__s
convenes132916913convenes
converses14311163converses
convexes20278273convexes
convokes17247703convokes
convulse1345443convulse_
convulsed1544383convulsed
copses104922473co__pses
cornhusks1841693cornhusks
corpses113913803co_rpses
corses84433463co__rses
coses76949493co___ses
cosmoses1239703cosmoses
costumes1258013costumes
coupes105022523co__upes
courses94218893co_urses
coutures10311993coutures
cowfishes2045723cowfishes
coynesses1437573coynesses
crocuses1239023crocuses
cruses88127713c__ruses
cultuses1037753cultuses
cuscuses1235863cuscuses
cypruses1534313cypruses
defuses114814593_defuses
diffuses1534823diffuses
dinguses1037643dinguses
douses74928933do__uses
dufuses11436593_dufuses
effuses1335903_effuses
focuses12159653fo_cuses
foetuses1136083foetuses
fondues11399313fondu_es
funguses1254713funguses
fuses85628423___fuses
geniuses935933geniuses
genuses83510883gen_uses
hocuses121710423ho_cuses
houses96032273ho__uses
incuses93514853_incuses
infuse93110573_infuse_
infused11329253_infused
infuser10298323_infuser
infusers11286143_infusers
ionises72916433ion_ises
joneses1438963jon_eses
lotuses74011253lo_tuses
louses66230283lo__uses
minuses93512703min_uses
momuses1159263mo_muses
mouses85531423mo__uses
nonfuel1045733nonfu_el
nonpluses1145713nonpluses
nonuse63212253non_use_
nonuser7299143non_user
nonusers8268003non_users
nouses64627163__nouses
onrushes1135213_onrushes
opuses84012243_o_puses
perfuses1358663perfuses
refuses104918553_refuses
reinfuses1245633reinfuses
rondures937713rondures
rouses65436283ro__uses
scouses93313243sco__uses
sinuses73011593sin_uses
soleuses838073soleuses
souses64229243so__uses
suffuses1435833suffuses
tongues879693tongu_es
tonsures869133tonsures
touses64229673to__uses
unconfuse1442983unconfuse_
unconfused1642953unconfused
unfused11319513_unfused
venuses103111413ven_uses
zonules1647793zon_ules

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622446.33023090.4
3Display Results2442440.1102218.2
 (SQL Overall)1786912446.86026048.3
 
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.