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

197 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
bouse7593185(None) 
blouse84714721blouse
boule74828041boule
bourse84414331bourse
boused95322881boused
bouses84931781bouses
bousy104917841bousy
bowse105420631bowse
douse66329721douse
house89131421house
louse56131011louse
mouse77133001mouse
rouse56634701rouse
souse56530771souse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arouse65019982arouse
base64847022b_ase
bemuse1038942bemuse
birse74517402birse
bise66437092b_ise
blase75524232blase
bloused104310642bloused
blouses94014462blouses
blousy11459122blousy
blue65328462blu_e
blues75127042blues
blume95619892blume
blush105115312blush
boas66150832boas_
boast75935702boast
bobs86340642bobs_
bocce114313112bocce
boche124216952boche
bode75838752bo_de
bodes84935102bodes
bods76244712bods_
bogie89524102bogie
bogle85821682bogle
bogs75742752bogs_
bogus85616472bogus_
boite74426322boite
bole66448692bo_le
boles75448602boles
bolus79125542bolus_
boluses94113832boluses
bombe115519312bombe
bone65949322bo_ne
bones76446532bones
bonne75124712bonne
bonus75324322bonus_
bonuses94212952bonuses
bonze165119352bonze
boos67955032boos_
boost75132472boost
booze164718912booze
bops86037982bops_
bore66051332bo_re
bores76448252bores
borne77926792borne
bos57966812bo_s_
bosh96328972bo_sh
bosk105825732bo_sk
boss65938342bo_ss
bossed94816532bossed
bosses85925402bosses
bossy105515972bossy
bosun75113592bosun
bots66453952bots_
boucle103712782boucle
bouffe14438312bouffe
bough115719312bough
bougie93613272bougie
boules84925972boules
boulle84614612boulle
bounce104014832bounce
bound84819582bound
bourg84113842bourg
bourn75518482bourn
bourne83714092bourne
bourses94014302bourses
bout66353292bou_t
bouts75131312bouts
bows96242862bows_
bowsed125715972bowsed
bowses115718862bowses
boxes145625072boxes
boys96737332boys_
brose75227032brose
browse115713852browse
bruise83412872bruise
brume95817982brume
brush105917472brush
brusk114912432brusk
brute75321782brute
burse75527252burse
bus56950972b_us_
bused85624492b_used
buses75936012b_uses
bush96630712b_ush
busk105429222b_usk
buss65134912b_uss
bust65947782b_ust
busy94727172b_usy
bute66739672b_ute
cause75225352cause
chouse116017562chouse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
cruse75726102cruse
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
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
obese75212422obese
obtuse8147482obtuse
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.0931921408.6
2DLD Change Limit538001971.62633087.3
3Display Results1971970.0464282.6
 (SQL Overall)1786911971.765101241.4
 
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.