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

182 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
nonfat951218(None) 
nonfact1248891nonfact
nonfan948291nonfan
confab1347062confab
confit113316402confit
nona46929062non_a_
nonart6319192nonart
nonas55126652non_as
nonet54540842non_et
nonfacts1346072nonfacts
nonfans1037532nonfans
nonfarm1246512nonfarm
nonfatal1146052nonfatal
nonfatty1443292nonfatty
nongay10169152nongay
nonman8412362nonman
nonmeat9312772nonmeat
nonpar8168992nonpar
nonpast939032nonpast
nontax1348412nontax
nonwar9159422nonwar
nougat74712652nougat
antifat10314253antifat
boat66360313bo__at
bobcat12411253bobcat
boniato947283boniato
bonita8312943bonita
bonnet85524633bonnet
bonsai838463bonsai
coat67558353co__at
coft97939683co_f_t
combat12316753combat
comfit133112423comfit
confabs1435393confabs
confect143614273confect
confer114018683confer
confits122811423confits
conflate13311173conflate
confute1239263confute
conga85419873conga_
congas94417033congas
connate9315753connate
contact1144020683contact
cowpat13312033cowpat
defat95426693_defat
doat56947673do__at
dona55529633don_a_
donas65926473don_as
donate73619503don_ate
donga76718423donga_
dongas84914613dongas
donna66215033donna_
donnas75511323donnas
donut6324513don_ut
eonian6311833eonian
fat68178083___fat
fondant11311143fondant
font77143753fon__t
fontal9313143fontal
forgat104018583forgat
format113021353format
gnat56034433_gn_at
goat56250833go__at
gonad75216053gon_ad
gonia64117533gonia_
honan85319773hon_an
honda9414983honda_
hondas10313353hondas
honest94822423honest
infant92315133_infant
korat94934433ko_rat
loft76539143lo_f_t
longan75612363longan
loofa85912813loofa_
loofah12375813loofah
loofas9429833loofas
loquat1558283loquat
lovat8321043lo_vat
manat76039993man_at
moat66352033mo__at
monad85519473mon_ad
monas74732153mon_as
mongst93512603mongst
monist84324983monist
nakfa1236093nakfa_
nakfas1334683nakfas
nana46632903nan_a_
nanas55928633nan_as
neat46356783__neat
neonate7311333neon_ate
ninja1258093ninja_
ninjas1386303ninjas
nocent83217413nocent
nodal64717793no_dal
noma67529463no_ma_
nomad86016183no_mad
nomas74726413no_mas
nonage7313683nonage
nonarts7311303nonarts
nonbank1345903nonbank
noncash1245163noncash
nonce75719823non_ce
nonces84418833nonces
noncom1039683noncom
none45743173non__e
nonego737013nonego
nones55639133non_es
nonets64118703nonets
nonfactor1445273nonfactor
nonfinal1147703nonfinal
nonfocal1346443nonfocal
nonfood1156653nonfood
nonfuel1045733nonfuel
nongame1038183nongame
nongays11176533nongays
nonmen8412833nonmen
nonoral7313603nonoral
nonpaid1048073nonpaid
nonparty1345553nonparty
nonpasts1046553nonpasts
nonpeak1345473nonpeak
nonplay1246683nonplay
nonrated9310843nonrated
nonsuit7811343nonsuit
nonuse63212253nonuse
nonwage1137163nonwage
nonwars10109003nonwars
nonyl849773non_yl
nonyls957853nonyls
noonday1144603noonday
nopal75517103no_pal
noria55722183noria_
norias65518203norias
normal83213533normal
not39474663no___t
nota46830773no_ta_
notal55221353no_tal
notate63217863no_tate
nougats8427413nougats
nought104713963nought
nounal639813nounal
nova76518953no_va_
novae85913123no_vae
novas85215363no_vas
noway111112843no_way
nowt78833753no__wt
numbat10312083numbat
oat39888263_o__at
ofay106416103_o_fay
offal1136243_offal
oft67744063_o_f_t
oncet74626543_oncet
onlay84212943_onlay
onset54730173_onset
ponent82821593ponent
qanat144426843qan_at
snowcat1245333snowcat
sofa75625603so_fa_
sofar86115493so_far
sofas85320713so_fas
soffit1237883soffit
soft76942823so_f_t
softa86415183so_fta
sonant6621953sonant
sonar56523423son_ar
sonata6313223son_ata
sonnet65923503sonnet
sunfast1038503sunfast
toft77441653to_f_t
tomcat101013453tomcat
tonal53724303ton_al
tonga65619693tonga_
tongas74315523tongas
tonlet62924703tonlet
unfit84518563_unfit
unhat81119263_unhat
wombat1339863wombat
wont75842503won__t
zona136321963zon_a_
zonae145116443zon_ae
zonal145116853zon_al
zonate154114923zon_ate

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161824.81323419.1
3Display Results1821820.0603033.3
 (SQL Overall)1786911825.24934042.9
 
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.