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

164 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
firmness133474(None) 
airiness8412222airiness
dimness1038842di_mness
direness9311302direness
fairness1136562fair_ness
farness102912202far_ness
fieriness1238632fieriness
filminess1435982filminess
filmless1344552filmless
fineness11310652fineness
fireless112810592fireless
firmers124711442firm_ers
firmest1239272firm_est
firmnesses1535622firmnesses
firstness1245012firstness
fitness10299392fi_tness
formless13248082formless
grimness1176002grimness
kirmess13234312kirm_ess
miriness10310462miriness
primness1276762primness
trimness1067562trimness
warmness1337062warmness
wiriness1138952wiriness
aimless93610813ai_mless
airless73712043air_less
aridness939233aridness
armless9369943_armless
bareness10912813bareness
baroness101210063baroness
biasness1035813biasness
bigness1038193bi_gness
brimless1235273brimless
calmness1236643calmness
curtness1037263curtness
darkness13247343darkness
dirtiness1039473dirtiness
dryness11114783_dryness
eeriness8311873eeriness
faintness1235833faintness
farmers124315263farm_ers
fastness11238763fastness
fatness103311293f_atness
fellness1135913fellness
ferments13311473ferments
fernless1136063fernless
fewness1335003f_ewness
feyness1334923f_eyness
fierceness1543793fierceness
figments1446943figments
filmers124211293film_ers
filmiest1338553filmiest
filmsets1353413filmsets
fines86644263fi__ne_s
finesse10187643fi__nesse
finest94321733fi__nest
finless102810783fi_nless
firers94922683fir__ers
fires85740753fir__e_s
firings114112333firin_gs
firmans12238523firm_ans
firmed125411883firm_e_d
firmer114712443firm_e_r
firms105217423firm___s
firns86018543fir_n__s
firriest112310433firriest
fishiness1537343fishiness
fishless1436413fishless
fishnets1445633fishnets
fitments1376793fitments
fixedness2043713fixedness
flatness1138153flatness
foaminess1437503foaminess
foamless13195843foamless
fondness1237213fondness
fordless12289003fordless
forkiness16268703forkiness
forkless15267433forkless
formalness1544833formalness
formers128217953form_ers
formes114623713form_e_s
fortress1136753fortress
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
freeness11710443freeness
fullness1135443fullness
fulness10248963f_ulness
furanes103214863furane_s
furless103210143fur_less
furriness12287603furriness
germiness1257693germiness
glumness1135203glumness
goriness9310753goriness
gormless11235443gormless
griminess1236723griminess
hairiness1238013hairiness
hardness122411083hardness
harmless1337403harmless
harness102413933har_ness
highness1536053highness
hipness12277383hi_pness
iciness938863_iciness
iffiness1435023iffiness
illness736473_illness
ireless72312243_ireless
ironers74813553_ironers
irones64724013_irone_s
ironness836953_ironness
kermess13396223kerm_ess
kindness13236653kindness
likeness12229863likeness
liminess10510643liminess
limners93311563li_mners
limpness1246703limpness
lioness739103li_oness
liteness82213213liteness
liveness112411393liveness
lornness836493lornness
mildness1136523mildness
moreness10911573moreness
niceness1039843niceness
nighness1236103nighness
normless10235923normless
oiliness8311563oiliness
pertness10310093pertness
pinkness1436513pinkness
pipiness1238003pipiness
pixiness1736093pixiness
primeness1338653primeness
pureness101110183pureness
rareness81112853rareness
richness1337433richness
rifeness1138593rifeness
riminess10510103riminess
rimless9369363ri_mless
ripeness1039373ripeness
sickness1437833sickness
simnels976103si_mnels
siziness1737423siziness
slimness1036523slimness
soreness8914793soreness
spryness1334003spryness
sureness8912903sureness
tartness82210133tartness
termless1036233termless
tidiness938793tidiness
tininess8310633tininess
tiredness1036933tiredness
tireless82510263tireless
titaness836723titaness
trigness968403trigness
vileness1139983vileness
wariness11313213wariness
weirdness1343593weirdness
wideness12259473wideness
wildness1236203wildness
wiliness1139113wiliness
wireless11249633wireless
wiseness112010753wiseness
witness103010013wi_tness
worminess14127613worminess
wornness1136363wornness
wryness13113983_wryness

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 Limit1461621647.11020557.2
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.59623524.4
 
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.