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 “folky” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
folky15921471(None) 
foley115222301foley
folk116021541folk_
folks126017121folks
folksy16484981folksy
folly115022601folly
forky156119641forky
yolky15529521yolky
alky115920342_alky
balky145418242balky
bosky145612392bosky
bulky146215572bulky
cocky164215932cocky
coky137526822co_ky
colby124415062colby
colly104926772colly
coly96940532col_y
conky145818742conky
cooky145321362cooky
corky145221152corky
dolly96125202dolly
dorky135518742dorky
felly114922802felly
filly114424902filly
filmy136114042filmy
flaky155715582flaky
flay106332802f_lay
fley106626852f_ley
flocky18468422flocky
fluky154512292fluky
fly97124952f_l_y
foamy135313202foamy
fogey125617872fogey
foggy136714542foggy
fogy115923182fo_gy
fold86528942fol_d
folds95221692folds
foleys123810462foleys
folia83618932folia
folic105319322folic
folio83820882folio
folkie13369612folkie
folkway2043352folkway
footy115820532footy
foray115023972foray
forby135317672forby
fork115930942fork_
forks125324682forks
forty114824272forty
foully1239012foully
foxy176517752fo_xy
foy96044262fo__y
fozy197017162fo_zy
fully114820862fully
funky154315132funky
golly95121102golly
gooky135818032gooky
holey115626902holey
holk116027942holk_
holks124720562holks
holly114824432holly
holy106333432hol_y
honky156218522honky
hooky155220262hooky
hulky155312472hulky
joky186215312jo_ky
jolly154517512jolly
jolty155713032jolty
kooky114412872kooky
lolly85120662lolly
milky144014442milky
moldy115014652moldy
molly105222492molly
moly96031912mol_y
nooky124814812nooky
oaky116419952_oaky
oldy85316842_oldy
pocky165314602pocky
poky135922152po_ky
polka11310412polka
poly96235152pol_y
porky145019332porky
rocky144513852rocky
rooky126117622rooky
silky125315822silky
sulky124715362sulky
talky126215682talky
wonky154011772wonky
yolk116218992yolk_
yolks125412772yolks

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 Limit53800902.14025140.2
3Display Results90900.0303000.0
 (SQL Overall)178691902.48371965.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.