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

271 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
choosey1545923(None) 
choose115116141choose_
chooser124412961chooser
chooses125717411chooses
choosy14459101choos_y
chaoses124715112chaoses
chokey184811712ch_okey
choosers134810862choosers
choosier1337162choosier
chose105925402ch_ose_
chosen116014132ch_osen
choses115825122ch_oses
chouse116017562chouse_
choused135012462choused
chouser125212942chouser
chouses125117812chouses
chowse144711752chowse_
chowsed16478602chowsed
chowses155611282chowses
cooey105828222c_oo_ey
cookey155414332c_ookey
cosey106226712c__osey
goosey105913512_goosey
hooey114926602_hoo_ey
hookey164713932_hookey
horsey125115402_horsey
hosey116127022_h_osey
phooey14379232phoo_ey
ahorse9311513ahorse_
blooey115110793bloo_ey
boogey124711523_boogey
caboose1138273caboose_
cabooses1237863cabooses
causey113513273c_ausey
chaise114916413chaise_
chaises124317493chaises
chantey154112543chantey
chaos105622863chaos__
charley15118273charley
chase105127123ch_ase_
chased125019293ch_ased
chaser114918383ch_aser
chases115128233ch_ases
chasmy16468543ch_asmy
chasse115114603chasse_
chassed134712133chassed
chasses124017503chasses
cheese113812763cheese_
cheesed133910683cheesed
cheeses123613103cheeses
cheesy14419193chees_y
chesses124112633chesses
chesty144610503ch_esty
chimley1785163chimley
chimney1795483chimney
chisel112111943ch_isel
chloroses1447673chloroses
chocked194411613chocked
choice132010523choice_
choicely1843823choicely
choicer14197893choicer
choices142010613choices
choired13349343choired
choke145118023ch_oke_
choked164914793ch_oked
choker154314373ch_oker
chokes154917383ch_okes
chokier1638043chokier
choky175711223ch_o_ky
choler113717153ch_oler
cholos114716853cholos__
chomped17329773chomped
chomper163810073chomper
chook146015043choo__k
chooks155312793choo_ks
choosiest1437323choosiest
choosing142010133choosing
chopped174511003chopped
chopper163611893chopper
choppy18376293ch_oppy
chops125019873chops__
chorded144710553chorded
chore105126763ch_ore_
chorea115216083ch_orea
chored125321883ch_ored
chores114828023ch_ores
chorten122811303chorten
chorused1446133chorused
choruses1339983choruses
chousers134610183chousers
choush14549063chous_h
choushes1637623choushes
chowder16387803chowder
chowed154914643ch_owed
chows135618203chows__
christy1536623christy
chrome133214813chrome_
chromed153510923chromed
chromes142914933chromes
chromy16309903chro_my
chutney1533823chutney
close76425223c_lose_
closed95317963c_losed
closely1237053c_losely
closer84918203c_loser
closes85425593c_loses
closet85226603c_loset
cohos105921853cohos__
cohosh14517123cohos_h
cohoshes1635873cohoshes
cohost115217213cohos_t
cohosted1436133cohosted
cohosts12398803cohosts
comose105016843comose_
coney105932883c__oney
convey144610223c_onvey
cooed84534343c_oo_ed
cooee74531023c_oo_ee
cooeed95917863c_ooeed
cooees85621893c_ooees
cooer74831013c_oo_er
cooeys114914483c_oo_eys
cooked135921363c_ooked
cooker124722453c_ooker
cookery164210393c_ookery
cookeys16478503c_ookeys
cooky145321363c_oo_ky
cooled95224583c_ooled
cooler84824713c_ooler
coolly114811393c_oolly
cooly105525423c_oo_ly
cooped114821603c_ooped
cooper104221123c_ooper
coopery143910273c_oopery
coos67456493c_oos__
cooter85128613c_ooter
copse95623923c_opse_
copses104922473c_opses
corse75036183c_orse_
corses84433463c_orses
corset85636223c_orset
cosec96320183c__osec
coses76949493c__oses
coset75748843c__oset
coseys115215813c__oseys
cosset84125863c_osset
cosy97232703c__os_y
covey136121783c__ovey
cozey196718543c__ozey
crooked143910943crooked
crooker134111093crooker
crookery17415993crookery
crooned103813343crooned
crooner93714043crooner
crosse85216303crosse_
crossed105313893crossed
crosser95015463crosser
crosses94220793crosses
crossly1277273crossly
crouse84619363crouse_
crousely1346563crousely
curtsey1255013curtsey
cymose13429653cymose_
cymosely1842973cymosely
dhooly13457143dhoo_ly
echoey14397853ech_o_ey
flooey123910173floo_ey
floosy12368153floos_y
ghosty13467213gh_osty
gooey95522863_goo_ey
gooney106612313_gooney
goose65925903_goose_
goosed86817033_goosed
gooses75723053_gooses
goosy96018883_goos_y
hockey184813153_hockey
hoise85224773_hoise_
hoised105117433_hoised
hoises94823673_hoises
hokey155422183_h_okey
holey115626903_h_oley
homey135924843_h_omey
homosex1936123_homosex
honey115629913_h_oney
honkey165113823_honkey
hooded114616743_hooded
hoody124919723_hoo_dy
hooeys125512313_hoo_eys
hoofed134614893_hoofed
hoofer124014953_hoofer
hooked145320553_hooked
hooker134820173_hooker
hookeys17448953_hookeys
hooky155220263_hoo_ky
hooly115022223_hoo_ly
hooped125518183_hooped
hooper114518313_hooper
hooray123011373_hooray
hooted104422653_hooted
hooter94123923_hooter
hooty115022433_hoo_ty
hooved134713123_hooved
hoover124314433_hoover
hooves124815483_hooves
horse86132653_horse_
horsed105321083_horsed
horses94729343_horses
horsy116318393_hors_y
hose76547243_h_ose_
hosed95830983_h_osed
hosel86024813_h_osel
hosen85623883_h_osen
hoser811529763_h_oser
hoses85443173_h_oses
hoseys124614003_h_oseys
house89131423_house_
housed105624103_housed
housel95217043_housel
houser95322283_houser
houses96032273_houses
looey84822913_loo_ey
looney94712403_looney
loose56627683_loose_
loosed75520893_loosed
loosely1036713_loosely
loosen66615963_loosen
looser65219943_looser
looses67328243_looses
mooley11311633_mooley
moose76327193_moose_
mosey105922873__mosey
mousey115216193_mousey
noose55624063_noose_
noosed75018013_noosed
nooser65517823_nooser
nooses65623643_nooses
nosey85619883__nosey
phoney143612983ph_oney
phoresy1534653phoresy
photoset13414273photoset
ptooey11346413ptoo_ey
rechoose13137343rechoose_
rechooses14107613rechooses
roose56127093_roose_
roosed75621593_roosed
rooser63921883_rooser
rooses65526233_rooses
schmoose15295973schmoose_
schmoosed17294303schmoosed
schmooses16275623schmooses
schooled1447043schooled
schooner1336623schooner
shooed103916073shoo_ed
shoofly1634343shoofly
shooled115212653shooled
shoos84226353shoos__
shooter103013973shooter
sooey84522433_soo_ey
spooney12418243spooney
those85218143th_ose_
whimsey18373893whimsey
whoofed17374513whoofed
whooped16326933whooped
whoopee15287513whoopee
whooper15297153whooper
whoosh15244353whoos_h
whooshed1833453whooshed
whooshes1734413whooshes
whoosis1335443whoosis
whose114914533wh_ose_
zooey173914803_zoo_ey

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272716.51620568.9
3Display Results2712710.0932914.0
 (SQL Overall)1786912716.76526414.0
 
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.