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

123 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
fondant1131114(None) 
fondants1246201fondants
fondest11312402fondest
fonding123815422fonding
formant123416002formant
mordant10312402mordant
pendant10314852pendant
sonant6621952son_ant
abundant1145453abundant
andante8311273_andante
bandana10179463bandana
bondage1138253bondage
bonding113318433bonding
bondman1238043bondman_
candent10417363candent
concent114422513concent
condone102616293condone
conduct121411593conduct
conduit10713083conduit
confidant1547623confidant
conodont11411153conodont
consent93723113consent
constant10515593constant
contact1144020683contact
content94326153content
convent123919413convent
coolant9316463coolant
courant9317973courant
defendant1445443defendant
dopant9316133do_pant
dormant102814373dormant
eonian6311833eonian_
faineant1146743faineant
fandango1342993fandango
fantast10311703fantast
fending123717603fending
fenland1135693fenland
finding124116543finding
foeman11311233foeman_
folding123912443folding
foldout1149533foldout
foment113718303fo_ment
fond86330953fond___
fonded115717043fond_ed
fonder104120063fond_er
fondle104412943fond_le
fondled12399423fondled
fondler11348883fondler
fondles113512613fondles
fondling13189353fondling
fondly13299043fond_ly
fonds95824823fond__s
fondu96013973fond__u
fondue104510493fond_ue
fondued12466363fondued
fondues11399313fondues
fonduing13245893fonduing
fondus105210943fond_us
font77143753fo___nt
fontal9313143fonta_l
fontanel1145553fontanel
fontina1038633fontina
fording123717043fording
fordone1149383fordone
forgat104018583forga_t
forint9325023fo_rint
formants13269953formants
format113021363forma_t
fornent10312933fornent
forwent13310533forwent
founding133010793founding
fount84727033fo__unt
foxhunt2043173foxhunt
fundament1544953fundament
funding124113663funding
gardant9314463gardant
honan85319773hon_an_
honans94814503hon_ans
honda9414983honda__
hondas10313353honda_s
incant82418513_incant
indent73021243_indent
infant92315133_infant
inundant945783inundant
jordan1468063jordan_
jordans1566833jordans
lindane839033lindane
longan75612363longan_
longans84510813longans
montane91313623montane
mordants1137143mordants
mordent10313993mordent
mundane1038073mundane
nonart6319193non_art
nonbank1345903nonbank
nondance1148243nondance
nonfact1248893nonfact
nonfan948293nonfan_
nonfans1037533nonfans
nonfat9512183nonfa_t
nonman8412363nonman_
nonpast939033nonpast
octant81216553_octant
oxidant1547363oxidant
pandani1039903pandani
pedant9319493_pedant
pendants1139093pendants
pendent10314723pendent
pennant9312493pennant
ponding114317083ponding
ponent82821593pon_ent
randan7315253randan_
randans8313213randans
rodent7519243ro_dent
soldan73511853soldan_
soldans83210403soldans
sonants7511233son_ants
sonorant8411703sonorant
soudan73210353soudan_
soudans8309353soudans
tenant6322473ten_ant
verdant11313293verdant
volant9316323vo_lant

Search took 8 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.406440125.6
2DLD Change Limit1340271236.81319672.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.26524596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.