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

122 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
folded11421279(None) 
folder104317541folder
fonded115717041fonded
forded115020391forded
molded104414081molded
balded105417512balded
boded95124962bo_ded
bolder94820932bolder
bolled94722652bolled
bolted94617802bolted
bonded104719952bonded
codded114515302codded
coded95433182co_ded
colder95121852colder
coled85540762col_ed
corded105923352corded
doled75430912dol_ed
dolled83518072dolled
enfolded1345432enfolded
faded105025242f_aded
farded114518952farded
felled103720302felled
felted103714652felted
fended114216912fended
feuded114010002feuded
fielded12206812fielded
filed95331902fil_ed
filled104922262filled
filmed124610362filmed
fled85429772f_l_ed
flied96519432f_lied
flooded12307932flooded
flowed133513762flowed
flued95021252f_lued
foaled104515962foaled
foamed126014402foamed
fobbed144112612fobbed
fodder114712112fodder
fogged125518372fogged
foiled104618402foiled
foined105915012foined
fold86528942fol__d
folders113514392folders
folds95221692fold_s
foldup1233812foldup
foley115222302fol_ey
folioed1138032folioed
folles93820472folles
fonder104120062fonder
fondled12399422fondled
fondued12466362fondued
fooled104317822fooled
footed104418622footed
fopped144012672fopped
forced126316522forced
fordid113512052fordid
forged115519322forged
forked145217142forked
formed125021172formed
fouled104315972fouled
founded124011422founded
fowled133914102fowled
foxed165115212fo_xed
fronded12388862fronded
fulled103820652fulled
funded114413892funded
gelded94512112gelded
gilded94413222gilded
goaded94913712goaded
godded104811802godded
golden84411152golden
golder84417602golder
golfed11569762golfed
holden104113952holden
holder104619652holder
holed95634132hol_ed
holked144913662holked
hooded114616742hooded
horded115420482horded
infolded1375662infolded
jolted143510632jolted
loaded84616872loaded
loided83414022loided
lolled74315822lolled
lorded84916732lorded
melded104714712melded
milded104416152milded
molder93819272molder
molted94217472molted
moulded11348062moulded
nodded94012122nodded
olden65114852_olden
older65121172_older
podded115012712podded
polder94019252polder
poled84934842pol_ed
polled94022002polled
ponded105218772ponded
refolded1337062refolded
rodded93713702rodded
rolfed104510522rolfed
rolled74220242rolled
scolded11358862scolded
sodded94113302sodded
solder73921342solder
soled65835172sol_ed
soloed74515742soloed
solved105312932solved
toled65934922tol_ed
tolled73819032tolled
unfolded1338312unfolded
upfolded1542882upfolded
voided114011132voided
voled95323722vol_ed
welded114013382welded
wilded113714502wilded
woaded115211602woaded
wolfed13428012wolfed
wooded114213682wooded
worded114316622worded
yodled11389652yodled
yolked14367152yolked

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 Filter178691825510.343520965.0
2DLD Change Limit825511222.22037185.1
3Display Results1221220.0304066.7
 (SQL Overall)1786911222.59368912.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.