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

161 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
yolks12541277(None) 
folks126017121folks
holks124720561holks
yelks126413621yelks
yocks144418371yocks
yoks116223741yo_ks
yolk116218991yolk_
yolky15529521yolky
balks114926292balks
bilks115117892bilks
bocks134526572bocks
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bonks116326462bonks
books115729712books
borks115727702borks
bosks115218852bosks
bulks115920612bulks
calks115421602calks
cocks135227162cocks
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
conks115525702conks
cooks115429142cooks
corks116028272corks
docks126022312docks
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
dorks105724442dorks
elks85820032_elks
folds95221692folds
folk116021542folk_
folksy16484982folksy
folky159214712folky
forks125324682forks
golds75421312golds
golfs95616102golfs
gooks105422882gooks
gowks136011952gowks
hocks144925492hocks
holds94623242holds
holes84748652holes
holk116027942holk_
holms105117802holms
hols76946292hol_s
holts85627912holts
honks125124522honks
hooks125027122hooks
howks155016852howks
hulks125715482hulks
ilks87218572_ilks
jocks185118082jocks
joles125230832joles
jolts125018882jolts
jouks165612342jouks
kolas94822232kolas
kolos94921212kolos
konks84917112konks
kooks85217262kooks
locks115126922locks
lolls512121732lolls
looks95124862looks
milks115020582milks
mocks135023822mocks
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monks116123392monks
mosks116117002mosks
nocks115121012nocks
nolos54423352nolos
nooks95420392nooks
oaks86527902_oaks
olds55926572_olds
oles46453472_oles
pocks135022962pocks
poles75351002poles
polis74731162polis
polka11310412polka
polkas1239102polkas
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
porks115124142porks
rocks114626412rocks
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rooks95325042rooks
silks94620682silks
soaks95220292soaks
socks114926082socks
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
sooks94425452sooks
souks94820522souks
sulks94818462sulks
talks94322692talks
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
voles86234042voles
volts85421292volts
walks126218502walks
woks116224902wo_ks
wolds95420182wolds
wolfs116214162wolfs
wonks124818342wonks
works125621902works
yacks144419812yacks
yaks116025202y_aks
yanks125316572yanks
yelk115320002yelk_
yells85821942yells
yelps105712992yelps
yerks125416562yerks
yeuks125110092yeuks
yills83921552yills
yobs96028082yo_bs
yock135924612yock_
yodhs12669012yodhs
yodles103714332yodles
yods86531182yo_ds
yogas96615602yogas
yoghs125410592yoghs
yogis95617742yogis
yoicks15375932yoicks
yok107335242yo_k_
yoke115626392yo_ke
yokes125223022yokes
yolked14367152yolked
yonis85020822yonis
yores85031322yores
yours85217882yours
yous76230652yo_us
yowes114926372yowes
yowls115715432yowls
yows106433122yo_ws
yucks144717192yucks
yuks116418022y_uks
yules84521582yules
zonks184815172zonks
zooks184716942zooks
zouks184410502zouks

Search took 3 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.313570897.8
2DLD Change Limit538001611.70331591.3
3Display Results1611610.0305366.7
 (SQL Overall)1786911612.04687336.8
 
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.