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

252 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
delouse83983(None) 
deloused1036981deloused
delouser936361delouser
delouses9310011delouses
blouse84714722_blouse
defuse105712722de_fuse
delousers1044662delousers
delude81910672del_ude
deluge8189402del_uge
deluxe14197302del_uxe
depose94215762depo_se
douse66329722d__ouse
louse56131012__louse
rehouse10311772rehouse
veloute1037732veloute
alehouse1146123alehouse
arouse65019983_arouse
because1136233because
bedehouse1544073bedehouse
belons84119413belons_
belows114614183belows_
bemuse1038943be_muse
bespouse1245113bespouse
bloused104310643_bloused
blouses94014463_blouses
blousy11459123_blousy
bouse75931853__bouse
carouse9614423carouse
cellule936523cellule
celoms10412123celoms_
cerous85821203cerous_
ceruse83914523ce_ruse
chouse116017563_chouse
clause84311503_clause
close76425223_clo_se
crouse84619373_crouse
debase94014473de_base
debone93714783debo_ne
debones103315113debones
debouch15124253debouch
debouche16123773debouche
debruise1143913debruise
decease1049523decease
deckhouse1973473deckhouse
declasse1165943declasse
decode104414743deco_de
decodes113914983decodes
decors94017773decors_
decos85522123deco_s_
decouple13114873decouple
decoys123911283decoys_
deduce1079253de_duce
defense1137503defense
defocus1335283defocus_
defocused16143533defocused
defocuses15134493defocuses
defogs1156683defogs_
deforce13267243deforce
defused125211093de_fused
defuser115110503de_fuser
defuses114814593de_fuses
defuze19487843de_fuze
degauss933923degauss
degust8310253de_gust
delaine8314793delaine
delate73827753del_ate
delates83526283delates
delays104014053delays_
dele56843083del___e
deleave1147723deleave
deles65139253del_es_
delete73620703del_ete
deletes83117933deletes
delfs94918673del_fs_
delfts10439673delfts_
delime9314043del_ime
delimes10314193delimes
delis64928543del_is_
delish105215613del_ish
delist74625053del_ist
dellies83622213dellies
dells66630943del_ls_
delousing1136303delousing
dels56745473del__s_
deltas74414823deltas_
delts65731793del_ts_
deluded10158763del_uded
deluder9168333del_uder
deludes91810643del_udes
deluged10167413del_uged
deluges9169263del_uges
delusive1245853del_usive
deluster936903del_uster
delve96018263del__ve
delves104917083delves_
demise94618323de_mise
demobs11429483demobs_
demode104013463demo_de
demonise11411933demonise
demons94917723demons_
demos86022993demo_s_
demoses103815833demo_ses
demote94817803demo_te
demotes104717673demotes
demount1049743demount
demure9311533de_mure
dengue838253dengu_e
dengues938183dengues
denote74118043deno_te
denotes83817003denotes
denounce1145103denounce
dense65923503de__nse
denture8311893denture
denude8169353de_nude
deplore1039483deplo_re
deplores1139533deplores
deploys1336523deploys_
deplume1255063deplume
depone93616553depo_ne
depones103717093depones
deposed113412033depo_sed
deposer104011843depo_ser
deposes103117213depo_ses
depots94716343depots_
depute94512303de_pute
despise1038683despise
detour778193detou_r
detoured1036513detoured
detours858043detours
detoxes1538803detoxes
detrude936083detrude
deuce84517493de__uce
devious1138523devious_
devise104215753de_vise
devoice13347343devoice
devolve14316063devolve
devons104512253devons_
devote104513783devo_te
devotee113811823devotee
devotes113713753devotes
devour1076703devou_r
devoured1335723devoured
devourer1235063devourer
devours1166643devours
devout10712993devou_t
devouter1235513devouter
diffuse1444383diffuse
dilute72911803dil_ute
diseuse83110723diseuse
disuse74012843d_isuse
doghouse1345413doghouse
dollhouse1344053dollhouse
dolors75115313dolors_
dolour75710133dolou_r
dolours8438823dolours
dormouse1144243dormouse
dose56442433d__o_se
douce85518423d__ouce
doused84821163d__oused
douser75621633d__ouser
douses74928933d__ouses
dowse96020813d__owse
drowse105010553d_rowse
druse64817663d__ruse
dulse65415043dul__se
effuse1234963_effuse
elapse857523_elapse
elope75219343_elo_pe
elopes85918163_elopes
else45923083_el__se
elude64517623_el_ude
elute54822573_el_ute
erose55727283_ero_se
espouse936403espouse
excuse1537423_excuse
felons93615763felons_
filose96112503filo_se
genoise839423genoise
grouse74315023_grouse
helos84928063helo_s_
helots95217703helots_
henhouse1445573henhouse
hexose16267843hexo_se
house89131423__house
icehouse1344763icehouse
jalousie1543143jalousie
jealous1438093jealous_
jealousy1842223jealousy
ketose105711813keto_se
loose56627683__loose
lose45144583__lo_se
louie55023513__louie
loupe75319513__loupe
loused74822913__loused
louses66230283__louses
lousy84617083__lousy
lowse87219903__lowse
melodise1147593melodise
melons84117713melons_
meous76120063me_ous_
mouse77133003__mouse
pelisse967063pelisse
pelorus939273pelorus_
peloruses1145873peloruses
perfuse1247663perfuse
peruse84016843pe_ruse
pilose84514243pilo_se
pilous84717753pilous_
rearouse839383rearouse
recluse95210773recluse
recoupe11109933recoupe
recourse1038383recourse
recuse85519163re_cuse
refuse94817513re_fuse
rehoused1239623rehoused
rehouses11312113rehouses
relapse947703relapse
release7312763release
relume8313273rel_ume
remorse9311713remorse
repose84121413repo_se
repousse1046053repousse
rerose63320853rero_se
reroute7313963reroute
retuse66617223re_tuse
reuse56025363re__use
rouse56634703__rouse
scouse84113633_scouse
serous65023563serous_
setose65114773seto_se
setous64917373setous_
souse56530773__souse
spouse84112513_spouse
teahouse1146073teahouse
telome8311923telo_me
telomes9310533telomes
telos55424523telo_s_
touse55430673__touse
unhouse1038923unhouse
unloose797863unloose
uprouse937223uprouse
veloce11310133velo_ce
velour9328763velou_r
velours10278083velours
veloutes1136153veloutes
velure939773vel_ure
venose9310843veno_se
venous93713193venous_
wellhouse1553853wellhouse
xylose1636763xylo_se
youse85322233__youse
zealous1637813zealous_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272525.95322514.2
3Display Results2522520.0763315.8
 (SQL Overall)1786912526.43527768.6
 
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.