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

156 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
unhouses113870(None) 
funhouses1544591funhouses
unhorses1138451unhorses
unhouse1038921unhouse_
unhoused1238151unhoused
bughouses1544742bughouses
bunkhouses19123392bunkhouses
chouses125117812_chouses
funhouse1444522funhouse_
henhouses1546172henhouses
houses96032272__houses
nouses64627162_n_ouses
nuthouses1246342nuthouses
outhouses12310662outhouses
rehouses11312112rehouses
unhorse1038582unhorse_
unhorsed1238832unhorsed
unhusks1443262unh_usks
unlooses8127292unlooses
uprouses1037552uprouses
alehouses1246583alehouses
animuses1037983animuses
ankuses1148203an_kuses
anuses66218773an__uses
arouses74921293_arouses
baghouses1545463baghouses
blouses94014463_blouses
bouses84931783__bouses
bughouse1445073bughouse_
bunkhouse18123653bunkhouse_
burnouses1144853burnouses
carouses10614503carouses
cathouses1439433cathouses
chooses125717423_chooses
choruses1339983_choruses
choses115825133_cho_ses
chouse116017563_chouse_
choused135012463_choused
chouser125212943_chouser
chousers134610203_chousers
choushes1637623_choushes
chowses155611283_chowses
clubhouses1742843clubhouses
delouses9310013delouses
doghouses1445353doghouses
douses74928933__douses
endorses959973endorses
enthuses1138253enthuses
espouses1037303espouses
ethoses10311763etho_ses
funguses1254713fun_guses
gashouses1345763gashouses
gnoses76515163gn_o_ses
grouses84616543_grouses
henhouse1445573henhouse_
hocuses121710423__hocuses
hoises94823673__hoises
horses94729343__horses
hoses85443173__ho_ses
hothouses1547763hothouses
house89131423__house_
housed105624103__housed
housel95217043__housel
housels105312133__housels
houser95322283__houser
housers104717813__housers
icehouses1445013icehouses
incuses93514853in_cuses
indorses968063indorses
infuses102711873in_fuses
inhumes1296883inh_umes
longhouses1444983longhouses
louses66230283__louses
madhouses1545743madhouses
mouses85531423__mouses
mungooses1283153mungooses
neguses837933_neguses
nexuses1436743_nexuses
niduses837013_niduses
noises65021853_n_oises
nonuses73313863_nonuses
nooses65623643_n_ooses
noses55435643_n_o_ses
nuthouse1145833nuthouse_
onuses65616253on__uses
outhouse11310883outhouse_
penthouses1546613penthouses
pothouses1449043pothouses
rehouse10311773rehouse_
rehoused1239613rehoused
rhuses94911793_rh_uses
roundhouses15102993roundhouses
rouses65436283__rouses
scouses93313243_scouses
souses64229243__souses
spouses92912813_spouses
taphouses1446553taphouses
teahouses1246513teahouses
touses64229673__touses
townhouses1653853townhouses
unabused1135623unabused
unamused1135793unamused
unaroused1046523unaroused
unboxes16208303unbo_xes
uncases93516553un_cases
uncaused1138453uncaused
unchokes17227273uncho_kes
unchosen1356283uncho_sen
uncloses10910943uncloses
unconfuses1553213unconfuses
uncouples1344813uncouples
uncrosses1146153uncrosses
underuses1039913underuses
undoes73917403undo__es
undoubles1243923undoubles
uneases73316263un_eases
unfocused1553403unfocused
unfused11319513un_fused
unglues836993unglu_es
ungues7412123un_gu_es
unhinges12266723unhinges
unholier1137283unholier
unholiest1246303unholiest
unhooded13277873unhooded
unhoods1137503unho_ods
unhooked16286743unhooked
unhooks1436413unho_oks
unhoped13249353unho_ped
unhouseled1442063unhouseled
unhousing1335883unhousing
unhusk1334263unh_us_k
unhusked1634603unh_usked
unionises947163unionises
uniques1667443uniqu_es
unloose797863unloose_
unloosed9117523unloosed
unloosen8125263unloosen
unloosens9153193unloosens
unpoised1139183unpoised
unposed10711903unpo_sed
unquotes1745353unquotes
unrobes9269733unro_bes
unrounds9145573unrounds
unsoured9310063unsoured
untruss736553untrus_s
untrusses945703untrusses
untunes72211253un_tunes
unused72012883un__used
unvoices13125163unvoices
unyokes1466733unyo_kes
uprouse937223uprouse_
uproused1135833uproused
uptosses1043973uptosses
uraeuses835383uraeuses
uruses63616503u__ruses
uteruses837183uteruses

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 Limit1461621566.31323152.5
3Display Results1561560.0801950.0
 (SQL Overall)1786911566.81326227.9
 
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.