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

266 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
fairness113656(None) 
farness102912201fa_rness
airiness8412212_airiness
airless73712042_airless
fainest10417702fai_nest
faintness1235832faintness
fairest10412292fair_est
fairies103516042fairie_s
fairnesses1357382fairnesses
fastness11238762fastness
fatness103311292fa_tness
firmness1334742f_irmness
fitness10299392f_itness
frailness1236542frailness
hairiness1238012hairiness
hairless1157412hairless
hairnets1195632hairnets
harness102413932ha_rness
unfairness1342812unfairness
vainness1136062vainness
wariness11313212wariness
acidness1136723acidness
aidless83612073_aidless
aimless93610813_aimless
airers64922313_air_ers
airest63825263_air_est
airiest74221013_airiest
airns55521033_airn__s
aptness9268573_aptness
aridness939223aridness
avidness1246113avidness
badness1039573ba_dness
bairnish1345473bairnish
bairns86710873bairn__s
baldness1137043baldness
bareness10912813bareness
barless94317003ba_rless
barneys12569563ba_rneys
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
biasness1035813biasness
bigness1038193_bigness
caginess11310303caginess
cairned1037643cairne_d
cairns85313303cairn__s
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
caress85720263ca_r_ess
carless95118493ca_rless
carnets93918403ca_rnets
carneys124310543ca_rneys
chariness14310063chariness
chicness1535593chicness
daftness1235533daftness
dailiness1038673dailiness
dailyness1343643dailyness
dairies84217733dairie_s
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
darnels83710433da_rnels
darners83815773da_rners
dearness939973dearness
dimness1038843_dimness
direness9311303_direness
dourness947683dourness
eagerness1046263eagerness
earless74316073ea_rless
earners74016453ea_rners
earnest7318733ea_rnest
earnests837853ea_rnests
easiness8313043easiness
eeriness8311873eeriness
evilness1135043evilness
faceless13269173faceless
facileness1545503facileness
fadedness1445613fadedness
fadeless12258323fadeless
faeries104118993faerie_s
faiences1337043faiences
failles102914133faille_s
fainer94717243fai_ne_r
fainters11349693fainters
faintest1139073faintest
faints94818783fai_n_ts
faired105915773fair_e_d
fairer95212063fair_e_r
fairgoers1342013fairgoers
fairings12388193fairings
fairish1338993fair_ish
fairlead1243513fairlead
fairleads1343023fairleads
fairs85825443fair___s
fairways1743873fairways
fairyism1643513fairyism
fairyisms1743073fairyisms
faithless1543903faithless
falseness1236093falseness
fameless13259203fameless
famines123216263famine_s
fanciness1437673fanciness
fanes84639893fa__ne_s
fangless1237663fangless
fanners103914653fa_nners
farcers124713443fa_rcers
farces115223323fa_rce_s
fardels11389893fa_rdels
farers95924053fa_r_ers
fares85852873fa_r_e_s
farfels13348213fa_rfels
farinas103215233farin_as
farinhas14325363farinhas
farinose1136463farinose
farles96025783fa_rle_s
farmers124315263fa_rmers
farnesol11113013fa_rnesol
farnesols12102743fa_rnesols
farnesses122310813fa_rnesses
farriers113610743farriers
fatalness1245773fatalness
fatless103212203fa_tless
fattiness12239373fattiness
fawners13388493fa_wners
fearless1137873fearless
feigners1235483feigners
fellness1135913fellness
fernless1136063f_ernless
fetidness1345443fetidness
fewness1335003f_ewness
feyness1334923f_eyness
fieriness1238623fieriness
fineness11310643fineness
fines86644263f_i_ne_s
finesse10187643f_i_nesse
finest94321733f_i_nest
finless102810783f_inless
fireless112810593f_ireless
firers94922683f_ir_ers
fires85740753f_ir_e_s
firmers124711443f_irmers
firmest1239273f_irmest
firns86018543f_irn__s
firstness1245013f_irstness
flakiness1636473flakiness
flatness1138153flatness
flirters11337933flirters
fluidness1344293fluidness
foaminess1437503foaminess
fondness1237213fondness
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
frankness1655223frankness
freeness11710443freeness
fullness1135443fullness
fulness10248963f_ulness
furless103210143f_urless
furriness12287603furriness
gainers84214593gai_ners
gainless9117403gainless
gameness112810693gameness
gaminess112911063gaminess
garners83815983ga_rners
garnets84115403ga_rnets
gastness9278473gastness
gayness1136843ga_yness
glariness1038553glariness
glibness1134133glibness
goriness9310753goriness
grimness1175993grimness
hairiest11612463hairiest
hairnet10911703hairne_t
haleness11312623haleness
halfness1435563halfness
hardness122411083hardness
haziness20248513haziness
heiress1036813heir_ess
heirless1146053heirless
hipness12277383_hipness
hoariness1238823hoariness
iciness938863ici_ness
iffiness1435023iffi_ness
kirmess13234313_kirmess
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
largess8408913la_rgess
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
lioness739103_lioness
madness10310073ma_dness
mailless10248583mailless
maleness10312313maleness
mariners103113863mariners
marines93928013marine_s
matiness102114753matiness
maziness19239543maziness
miriness10310463_miriness
naiveness1277493naiveness
nearness838313nearness
oarless73913373oa_rless
packness1636933packness
painless10108343painless
paleness10312983paleness
pastness102510503pastness
patness92912283pa_tness
patroness1137483patroness
plainness1155183plainness
poorness1036363poorness
primness1276763primness
rabidness12145263rabidness
raciness102413453raciness
raininess949273raininess
rainless8129703rainless
rankness12267943rankness
rapidness12155473rapidness
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
sailless82410373sailless
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
scariness11310183scariness
slimness1036523slimness
sourness839543sourness
staidness1037033staidness
stairless9185623stairless
tacitness1134873tacitness
tailless8239083tailless
tallness837103tallness
tameness102411253tameness
tarriness9229243tarriness
tartness82210133tartness
tautness8217183tautness
teariness9310633teariness
thinness11277163thinness
trigness968403trigness
trimness1067563trimness
vainest10315763vai_nest
validness13125363validness
vapidness15144423vapidness
vastness11257293vastness
voidness1235553voidness
waeness102512783wa_eness
waitress1135223waitress
wanness102610683wa_nness
warless104015103wa_rless
warmness1337063warmness
warners103315563wa_rners
waviness1437723waviness
waxiness1836723waxiness
weariness1238843weariness
weirdness1343593weirdness
wiriness1138953_wiriness
witness103010013_witness
yarners104312203ya_rners
zaires1539703zair_e_s
zaniness1738663zaniness

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.1731032896.0
2DLD Change Limit1461622667.51619446.8
3Display Results2662660.1102418.2
 (SQL Overall)1786912667.79922912.0
 
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.