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 “doofuses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
doofuses124428(None) 
confuses13310362confuses
defuses114814592d_efuses
diffuses1534832diffuses
doofus1036162doofu__s
douses74928932d_o_uses
dufuses11436592d_ufuses
arouses74921293aro_uses
blouses94014463blo_uses
boluses94113833_boluses
bonuses94212953_bonuses
bouses84931783_bo_uses
choruses1339983choruses
chouses125117813cho_uses
clonuses1057133clonuses
coituses1039623coituses
coleuses1039723coleuses
colobuses1346133colobuses
confuse1238853confuse_
confused1437033confused
confutes1339843confutes
contuses10413453contuses
cornuses10310033cornuses
corpuses12310063corpuses
crocuses1239023crocuses
defocuses15134493defocuses
defuse105712723d_efuse_
defused125211093d_efused
defuser115110503d_efuser
defusers12487363d_efusers
defuzes20398303d_efuzes
delouses9310013delouses
diffuse1444383diffuse_
diffused1643493diffused
diffuser1543153diffuser
diffusers1642783diffusers
dinguses1037643dinguses
dioceses1137113dioceses
discuses113112863discuses
diseuses93112763diseuses
disuses84015413d_isuses
dogfaces1554143dogfaces
dogfishes1745083dogfishes
doghouses1445353doghouses
doobies103915673doo_bies
doodies94218773doo_dies
doodles93614163doo_dles
doolees83711613doo_lees
doolies83920713doo_lies
doorless936713doorless
doozies173812723doo_zies
doses65938503d_o__ses
dosses76126273d_o_sses
douse66329723d_o_use_
doused84821163d_o_used
douser75621633d_o_user
dousers84817273d_o_users
dowses105718303d_o_wses
drogues9398393drogu_es
drosses84513823dro_sses
drowses114610233dro_wses
druses75517253d__ruses
effuses1335903_effuses
exoduses1644803exoduses
focuses12159653_focuses
foetuses1136083foetuses
fuses85628423___fuses
gooses75723063goo__ses
grouses84616543gro_uses
hocuses121710433_hocuses
hoofless14258013hoofless
houses96032283_ho_uses
infuses102711873_infuses
looses67328253loo__ses
lotuses74011253_lotuses
louses66230283_lo_uses
momuses1159273_momuses
mouses85531423_mo_uses
nonuses73313863_nonuses
nooses65623653noo__ses
nouses64627163_no_uses
onuses65616253__onuses
opuses84012243__opuses
perfuses1358663perfuses
profuse1237153profuse_
refuses104918553_refuses
roofies103014413roof_ies
roofless11316733roofless
rooses65526243roo__ses
rouses65436283_ro_uses
scouses93313243sco_uses
soleuses838073soleuses
souses64229243_so_uses
spouses92912813spo_uses
suffuses1435833suffuses
tonuses73612193_tonuses
tootses72910773too_tses
touses64229673_to_uses
woopses1237883woo_pses
zoonoses1746203zoonoses

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 Limit1461621006.28323263.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911006.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.