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

198 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
louse5613101(None) 
blouse84714721blouse
bouse75931851bouse
douse66329721douse
house89131421house
loose56627681loose
lose45144581lo_se
louie55023511louie
loupe75319511loupe
loused74822911loused
louses66230281louses
lousy84617081lousy
lowse87219901lowse
mouse77133001mouse
rouse56634701rouse
souse56530771souse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arouse65019982arouse
bloused104310642bloused
blouses94014462blouses
blousy11459122blousy
boule74828042boule
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bowse105420632bowse
cause75225352cause
chouse116017562chouse
clause84311502clause
close76425222clo_se
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
cruse75726102cruse
delouse839832delouse
dose56442432do_se
douce85518422douce
doused84821162doused
douser75621632douser
douses74928932douses
dowse96020812dowse
druse64817662druse
fosse86119462fosse
fuse76429992_fuse
goose65925902goose
gorse65926812gorse
gouge78220062gouge
grouse74315022grouse
hoise85224772hoise
horse86132652horse
hose76547242ho_se
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
joule124918202joule
joust125122292joust
lapse74917682lapse
lase46148512l_ase
lease55230262lease
lense54523432lense
lobe65535362lo_be
lobes75331002lobes
lobs66441082lobs_
lobule82910062lobule
locule83412032locule
locus74819992locus_
locust85312342locust
lode56240112lo_de
lodes66436912lodes
lodge76520082lodge
loess55714702loess
loge56837192lo_ge
loges66534202loges
logs57343112logs_
lone45849132lo_ne
longe66626462longe
looie55624242looie
loos49051122loos_
loosed75520892loosed
loosen66615962loosen
looser65219942looser
looses67328242looses
lope65941922lo_pe
lopes76437342lopes
lops66043352lops_
lore45850352lo_re
lores55045402lores
losel54419422lo_sel
loser54728672lo_ser
loses56742012lo_ses
loss45337962lo_ss
losses65925232losses
lossy85214642lossy
lost47951492lo_st
lots47652092lots_
lotte54923852lotte
lotus55718062lotus_
lotuses74011252lotuses
louche115212662louche
loud55228042lou_d
louden73711792louden
louder74414602louder
lough95118482lough
louies64525102louies
louis57322322louis
louma76213632louma
lounge75211212lounge
loup66028432lou_p
louped95316382louped
loupen84510292loupen
loupes84918052loupes
loups75319622loups
lour45430682lou_r
loured74617402loured
lours55125292lours
loury85716752loury
lousier72411622lousier
lout45952142lou_t
louted74920692louted
louts56330272louts
louver94110392louver
louvre9425682louvre
love75234762lo_ve
loves85332012loves
lowe75435312lo_we
lowes85732462lowes
lows75843012lows_
loxes125227472loxes
lube64731562l_ube
luce65132572l_uce
lude55331642l_ude
lues45943552l_ues
luge55531642l_uge
lune47140492l_une
lure45142462l_ure
lush75327692l_ush
lust47442602l_ust
lute46341012l_ute
luxe115222692l_uxe
lyase85512412lyase
lyse76320592l_yse
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
scouse84113632scouse
sous46947212sous_
soused74822982soused
souses64229242souses
spouse84112512spouse
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.0802233637.5
2DLD Change Limit538001981.76630464.3
3Display Results1981980.0603300.0
 (SQL Overall)1786911981.90693751.8
 
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.