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

180 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
souse5653077(None) 
bouse75931851bouse
douse66329721douse
house89131421house
louse56131011louse
mouse77133001mouse
rouse56634701rouse
scouse84113631scouse
sous46947211sous_
soused74822981soused
souses64229241souses
spouse84112511spouse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arouse65019982arouse
blouse84714722blouse
boule74828042boule
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bowse105420632bowse
cause75225352cause
chouse116017562chouse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
cruse75726102cruse
dose56442432do_se
douce85518422douce
doused84821162doused
douser75621632douser
douses74928932douses
dowse96020812dowse
druse64817662druse
espouse936402espouse
fosse86119462fosse
fuse76429992_fuse
goose65925902goose
gorse65926812gorse
gouge78220062gouge
grouse74315022grouse
hoise85224772hoise
horse86132652horse
hose76547242ho_se
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
joule124918202joule
joust125122292joust
loose56627682loose
lose45144582lo_se
louie55023512louie
loupe75319512loupe
loused74822912loused
louses66230282louses
lousy84617082lousy
lowse87219902lowse
moose76327192moose
morse76032702morse
moue65835572mou_e
moues75732842moues
moused94423302moused
mouser85822442mouser
mouses85531422mouses
mousey115216192mousey
mousse84813032mousse
mousy106716942mousy
muse67136032_muse
noise55723732noise
nonuse63212252nonuse
noose55624062noose
nose46739362no_se
nous46136982nous_
nouses64627162nouses
ose38147342_o_se
ousel55222402_ousel
oust46747442_oust
owse76321622_owse
pause75021832pause
poise75127892poise
pose66441732po_se
posse74722272posse
reuse56025362reuse
roose56127092roose
rose46148902ro_se
roue45941742rou_e
roues56039352roues
rouge65423442rouge
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
route55132072route
ruse45938932_ruse
sauce75121652sauce
saute55028082saute
scouses93313242scouses
scute75520942scute
seise54727852seise
sense55526822sense
shush113812542shush
shute84520342shute
slue45332192slu_e
slues54527172slues
slush85316572slush
smush104410582smush
soave84219052soave
sobs64941752sobs_
socle7419572socle
sods54940212sods_
soke85436262so_ke
sokes95031422sokes
sole46053672so_le
soles55547922soles
sols45448162sols_
solus54726982solus_
solute64016662solute
solve85618942solve
some66040382so_me
soms66239372soms_
sonde64622832sonde
sone46649982so_ne
sones55444142sones
sons46049552sons_
sonsie6614852sonsie
sonsy86416372sonsy
sops65244562sops_
sore47059532so_re
sores55454282sores
sorus54527582sorus_
sos37761602so_s_
sots45552442sots_
sou37853692sou__
soubise9118792soubise
sough95320462sough
souk86127172sou_k
souks94820522souks
soul46435712sou_l
souled75419822souled
souls55127362souls
sound64420022sound
soup66232912sou_p
souped95017672souped
soups75322942soups
soupy106115402soupy
sour45935892sou_r
source8410672source
soured74921862soured
sourer63620212sourer
sours55230502sours
souter64225922souter
south85223572south
sows75342492sows_
soys75233932soys_
spoused10349652spoused
spouses92912812spouses
spue66025522spu_e
spues75025382spues
spume95817312spume
stoure64814942stoure
stupe75217752stupe
sue35651462s_u_e
sues46247652s_ues
supe65932762s_upe
sure45447412s_ure
suss45229302s_uss
torse55833332torse
toused74122012toused
touses64229672touses
tousle64514652tousle
use36835162__use
worse86525262worse
yous76230652yous_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001801.64032804.9
3Display Results1801800.0463913.0
 (SQL Overall)1786911801.779100444.6
 
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.