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

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

132 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
douser7562163(None) 
dorser74819171dorser
doser66228561do_ser
dosser74417971dosser
dourer74215271dourer
douse66329721douse_
doused84821161doused
dousers84817271dousers
douses74928931douses
dowser104716081dowser
houser95322281houser
mouser85822441mouser
rouser65224081rouser
abuser85413682abuser
amuser84712622amuser
arouser74514422arouser
bouse75931852bouse_
boused95322882boused
bouses84931782bouses
causer84117782causer
chouser125212942chouser
courser94114802courser
couter84930202couter
dauber94112012dauber
defuser115110502defuser
delouser936362delouser
denser74115192denser
dobber114015412dobber
docker134417652docker
dodder94712912dodder
dodger95817042dodger
doer57734702do__er
doffer133911352doffer
dogger95216782dogger
doozer163910462doozer
doper86128392do_per
dopier93515922dopier
dormer94415892dormer
dorper94314562dorper
dorsel75315502dorsel
dorsers83516292dorsers
dose56442432do_se_
dosed76626912do_sed
dosers75723632do_sers
doses65938502do_ses
dossed84516632dossed
dossel74813642dossel
dossers84516232dossers
dosses76126272dosses
dossier83711692dossier
doter65428622do_ter
dotier73917032dotier
dotter74419342dotter
doubler103110082doubler
doubter10298352doubter
douce85518422douce_
douceur1043112douceur
dour56330432dou__r
dower95027702do_wer
downer104414922downer
dowse96020812dowse_
dowsed115015012dowsed
dowsers115013522dowsers
dowses105718302dowses
dozer158419272do_zer
dozier163611632dozier
druse64817662druse_
druses75517252druses
duper85519002d_uper
duster74919722d_uster
focuser12155782focuser
fouler93614902fouler
gouger86014362gouger
grouser84513692grouser
hoser811529762ho_ser
house89131422house_
housed105624102housed
housel95217042housel
housers104717812housers
houses96032272houses
jouster143311042jouster
looser65219942looser
loser54728672lo_ser
louder74414602louder
louse56131012louse_
loused74822912loused
louses66230282louses
lousier72411622lousier
louver94110392louver
momser104011412momser
mosser84618272mosser
mouse77133002mouse_
moused94423302moused
mousers95216442mousers
mouses85531422mouses
mousey115216192mousey
mousier93712462mousier
muser76024122_muser
nonuser7299142nonuser
nooser65517822nooser
nouses64627162nouses
ousel55222402_ousel
ouster64223732_ouster
outer55633302_outer
pauser84415962pauser
poiser84217242poiser
poser75128772po_ser
pourer84516042pourer
pouter83923982pouter
rooser63921882rooser
rouse56634702rouse_
roused75426442roused
rousers75220132rousers
rouses65436282rouses
rouster73517082rouster
router65025842router
sourer63620212sourer
souse56530772souse_
soused74822982soused
souses64229242souses
souter64225922souter
tosser64215662tosser
tourer64115072tourer
touse55430672touse_
toused74122012toused
touses64229672touses
touter63821032touter
trouser73812462trouser
user45023002__user
worser95117522worser
wowser125110202wowser
youse85322232youse_

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit825511322.73630172.1
3Display Results1321320.0304400.0
 (SQL Overall)1786911322.88961852.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.