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

174 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
kousso1035439(None) 
koussos11373901koussos
kusso9398031k_usso
cusso74912292_cusso
koss85224812ko_ss_
kouros1039182kouros
kussos10336422k_ussos
mosso74715182mo_sso
mousse84813032mousse
basso76017283_basso
boss65938343bo_ss_
bossy105515973bo_ssy
bourse84414333bourse
bouse75931853bou_se
boused95322883boused
bouses84931783bouses
bousy104917843bou_sy
bouts75131313bouts_
buss65134913_buss_
coss66143493co_ss_
coups95522473coups_
course85117783course
cousin8517163cousin
cuss65430613_cuss_
cussos84210003_cussos
doss56235043do_ss_
doums85417643doums_
douse66329723dou_se
doused84821163doused
douser75621633douser
douses74928933douses
foss76431643fo_ss_
fossa85812633fo_ssa
fosse86119463fo_sse
fouls87221433fouls_
fours85521493fours_
fuss76027933_fuss_
fussy115613953_fussy
gauss65613453gauss_
gesso649603_gesso
gouts64826173gouts_
gussy95314323_gussy
gusto65414643_gusto
hours85422393hours_
house89131423hou_se
housed105624103housed
housel95217053housel
houser95322283houser
houses96032283houses
hussy116812763_hussy
joss115925593jo_ss_
jouks165612343jouks_
journo13135293journo
joust125122293jou_st
jousts135011273jousts
khoums1594013khoums_
kiss85227403k_iss_
kissy125510313k_issy
knouts10438313knouts_
knurs94511153knurs_
koans95818623koans_
koas85635093ko_as_
kobo107422103ko__bo
kobos115616893kobos_
kobs105831083ko_bs_
koels94613903koels_
kohls12437803kohls_
kois85129403ko_is_
kojis16468443kojis_
kolas94822233kolas_
kolo87026223ko__lo
kolos94921213kolos_
konks84917113konks_
koodoo11107773koodoo
kooks85217263kooks_
kophs145010933kophs_
kops107031293ko_ps_
koras95927113koras_
kors85933013ko_rs_
kos76944823ko__s_
koto86323473ko__to
kotos95717703kotos_
koumis1237623koumis
koumiss1344313koumiss
koumys1543303koumys
koumyss1641143koumyss
kouroi1036513kouroi
kudo96115113k_u_do
kudos105011253k_udos
kues86426773k_ues_
kvass12507273kvass_
lasso55015683_lasso
loess55714703loess_
loss45337963lo_ss_
lossy85214643lo_ssy
louis57322323louis_
loups75319623loups_
lours55125293lours_
louse56131013lou_se
loused74822913loused
louses66230283louses
lousy84617083lou_sy
louts56330273louts_
moss67641033mo_ss_
mossy105217063mo_ssy
moues75732843moues_
mouse77133003mou_se
moused94423303moused
mouser85822443mouser
mouses85531423mouses
mousey115216193mousey
moussed10338913moussed
mousses94012703mousses
mousy106716943mou_sy
muss64933763_muss_
mussy104117643_mussy
nouns56717313nouns_
nous46136983nou_s_
nouses64627163nouses
ossa43714163_o_ssa
ouds56430103_ouds_
ours47237563_ours_
ousel55222403_ousel
oust46747443_ou_st
ousts55225703_ousts
outdo6312703_outdo
outgo6312093_outgo
outs45746963_outs_
ouzo133516933_ou_zo
ouzos143210413_ouzos
posse74722273po_sse
poufs105616063poufs_
pours74623183pours_
poussie936623poussie
pouts75530323pouts_
puss64830133_puss_
pussy105614843_pussy
roues56039353roues_
roups75118903roups_
rouse56634703rou_se
roused75426453roused
rouser65224083rouser
rouses65436283rouses
roust55532063rou_st
rousts617016723rousts
routs57133413routs_
souks94820523souks_
souls55127363souls_
soups75322943soups_
sours55230503sours_
soursop943033soursop
sous46947213sou_s_
souse56530773sou_se
soused74822983soused
souses64229243souses
suss45229303_suss_
torso56922143to_rso
torsos64815733torsos
toss45637973to_ss_
tours55325893tours_
touse55430673tou_se
toused74122013toused
touses64229673touses
tousle64514653tousle
touts54830393touts_
truss54916923truss_
tussor6378233_tussor
voussoir1141493voussoir
wuss75219333_wuss_
wussy115810343_wussy
yours85217883yours_
yous76230653you_s_
youse85322233you_se
zouks184410503zouks_

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161745.48320557.4
3Display Results1741740.0463782.6
 (SQL Overall)1786911745.92230174.1
 
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.