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

299 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
flatness113815(None) 
fatness103311291f_atness
farness102912202f_arness
fastness11238762fastness
fatless103212202f_atless
fitness10299392f_itness
flagless1235402flagless
flakiness1636472flakiness
flanes94522422fla_ne_s
flannels1134842flannels
flapless1335342flapless
flatbeds14364542flatbeds
flatlets1147372flatlets
flatnesses1337762flatnesses
flattens11357482flattens
flatters113814202flatters
flattest1138712flattest
flatuses1137172flatuses
flawless1434502flawless
fleetness1244752fleetness
gladness1036152gladness
lateness82614072_lateness
laxness1436042_laxness
neatness839152neatness
patness92912282_patness
saltness82610242saltness
slatiness92511362slatiness
whatness1435092whatness
alates64833973alat_e_s
alertness946053alertness
apartness1146053apartness
aptness9268573_aptness
awayness1443303awayness
badness1039573_badness
baldness1137043baldness
beatless103311593beatless
biasness1035813biasness
blackness1735663blackness
blandness1235973blandness
blankness1544673blankness
blarneys13183193blarneys
blathers134713793blathers
blatters104414093blatters
bleakness1543593bleakness
blotless10347153blotless
blueness1038213blueness
bluntness1144343bluntness
calmness1236643calmness
clatters103313913clatters
clawless1334123clawless
cleanness1144973cleanness
clearness1135633clearness
coatless1039693coatless
curtness1037263curtness
daftness1235533daftness
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deftness1236303deftness
drabness1135803drabness
elatedness1146033elatedness
elaters74420193elat_ers
elates65032363elat_e_s
exactness1843623exactness
fainest10417703f_ainest
faintness1235833faintness
fairness1136563fairness
falseness1236093falseness
falters103916473falt_ers
fanes84639893f_a_ne_s
fanners103914653f_anners
fatalness1245773fatalness
fates85139233f_at_e_s
fathers133916503f_athers
fatnesses121710463f_atnesses
fattens105111713f_attens
fattest102913063f_attest
fattiness12239373fattiness
fawners13388493f_awners
fearless1137873fearless
feastless1235043feastless
featest102715113feat_est
feathers143513243feathers
feetless1137383feetless
fellness1135913fellness
fewness1335003f_ewness
feyness1334923f_eyness
filminess1435983filminess
fineness11310653fineness
firmness1334743firmness
firstness1245013firstness
flabbiness1742523flabbiness
flaggers13328073flaggers
flakers143613273fla_kers
flakes134118873fla_ke_s
flakiest153210553flakiest
flambes14419503flambe_s
flameless1435353flameless
flamens124611063fla_mens
flamers124616363fla_mers
flames114723693fla_me_s
flamiest133111983flamiest
flamines13311643flamine_s
flaneur1034183fla_neur
flaneurs1133953fla_neurs
flangers123311373flangers
flanges113413273fla_nges
flankers15349303flankers
flanks133913403fla_n_ks
flannel1035423flanne_l
flans85327973fla_n__s
flappers15388383flappers
flares94521703fla_re_s
flashers143912653flashers
flashes133916103flashe_s
flashiness16105283flashiness
flaskets1534603flaskets
flatbed13397983flatbe_d
flatcaps1563403flatcaps
flatcars1344623flatcars
flatfeet1446213flatfeet
flatfish1744933flatfish
flathead1535813flathead
flatheads1644873flatheads
flatlet10312253flatle_t
flatliners13254073flatliners
flatlines12268433flatline_s
flats86429743flat___s
flatted114012943flatte_d
flatten10429653flatte_n
flatteners13164153flatteners
flatter103815963flatte_r
flattery14338293flattery
flattish1455263flattish
flattops1344553flattops
flatus94310783flat__us
flatwash1742423flatwash
flatways1744323flatways
flatwise1443973flatwise
flaunters1234513flaunters
flaunts1056133flaun_ts
flavines1437893flavine_s
flavones1435833flavone_s
flawiest14298583flawiest
flaxes165015353fla_xe_s
flaxiest18298193flaxiest
flayers133912033fla_yers
flenses1039473fl_enses
flintiness1345903flintiness
flites95122443flit_e_s
flitters114312173flitters
floatels11295663float_els
floaters112711513float_ers
floatiest1237293floatiest
fluidness1344293fluidness
flukiness1635453flukiness
flushness1544893flushness
fluters103713683flut_ers
flutes95421783flut_e_s
flutiest112610883flutiest
flutters114010823flutters
flyless1335003fl_yless
flytes123911563flyt_e_s
flytiers14254483flytiers
foaminess1437503foaminess
foamless13195843foamless
folates103218453folat_e_s
fondness1237213fondness
footless113710803footless
fortress1136753fortress
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
frailness1236553frailness
frankness1655223frankness
fraters103517213frat_ers
freeness11710443freeness
fretless1138063fretless
fullness1135443fullness
fulness10248963f_ulness
fustiness121910243fustiness
gastness9278483gastness
gayness1136843_gayness
giantess933893giantess
glariness1038553glariness
glaziness1935753glaziness
glegness1034613glegness
glibness1134143glibness
gluiness937373gluiness
glumness1135203glumness
grayness1235933grayness
greatness1036903greatness
haleness11312623haleness
halfness1435563halfness
haltless11308443haltless
harness102413933_harness
hatless103813443_hatless
heatless113011463heatless
hotness1038613_hotness
illness736473il_lness
inaptness1144333inaptness
irateness9310493irateness
justness1535323justness
laciness102112553_laciness
lameness102612673_lameness
lanes54946793_la_ne_s
lankness12237043_lankness
lanners73618333_lanners
largess8408913_largess
lateens74210553_lateens
latens64620213_lat_ens
latents75214313_latents
latest63822703_lat_est
latests73910313_lat_ests
lathers104321883_lathers
lathes95127503_lathe_s
latkes104715873_latke_s
lattens75014673_lattens
lattes65324203_latte_s
lawless1037033_lawless
laziness17239983_laziness
leanness837373leanness
lioness739103_lioness
liteness82213213_liteness
loathness1244703loathness
lostness837683lostness
lowness1037813_lowness
madness10310073_madness
maleness10312313maleness
maltiness112910573maltiness
matiness102114753_matiness
matless93014043_matless
meanness1037183meanness
meatiness11311183meatiness
meatless103410863meatless
meetness1036653meetness
mootness1036753mootness
nearness838313nearness
oblateness1244893oblateness
oldness836403ol_dness
oratress834553oratress
ovalness1134673ovalness
paleness10312993paleness
pastness102510503pastness
peartness1137773peartness
pertness10310093pertness
plainest10313613plainest
plainness1155193plainness
planeness1138163planeness
planers94517953pla_ners
planes85028083pla_ne_s
planets93914083pla_nets
planless1036823planless
planners10399943planners
planters102915333planters
platanes102711883platane_s
platens94213983plat_ens
platers93924093plat_ers
plates85432243plat_e_s
platies93722543platie_s
platiest103216093platiest
platters103415283platters
playless1334863playless
pleatless1134613pleatless
pliantness1263643pliantness
plotless10256793plotless
raptness1046733raptness
rawness1038153_rawness
realness8410443realness
sadness8310613_sadness
saltiness93312113saltiness
saltless8259343saltless
scantness1135733scantness
seatless83213003seatless
slackness1535433slackness
slaters73123733slat_ers
slates64934063slat_e_s
slathers113914783slathers
slatiest82616273slatiest
slimness1036523slimness
slitless8268143slitless
slowness1135013slowness
slyness1035263sl_yness
smartness1136143smartness
softness1136433softness
squatness1844943squatness
sultaness945613sultaness
swartness1236113swartness
tallness837103tallness
tartness82210133tartness
tautness8217183tautness
titaness836723titaness
unaptness1154173unaptness
vastness11257293vastness
waeness102512783_waeness
wanness102610683_wanness
weakness1535353weakness
wetness10277723_wetness
witness103010013_witness

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622996.57622226.6
3Display Results2992990.1262373.0
 (SQL Overall)1786912997.12525079.4
 
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.