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 “faintnesses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
faintnesses144714(None) 
daintinesses1346242daintinesses
faintness1235832faintne_s_s
fairnesses1357382fai_rnesses
fastnesses1389082fa_stnesses
fatnesses121710462fa__tnesses
finenesses13310712f_inenesses
fitnesses12219372f_i_tnesses
flintinesses1546322flintinesses
gauntnesses1245172gauntnesses
quaintnesses2143822quaintnesses
raininesses11310482raininesses
vainnesses1337342vain_nesses
airinesses102613613_airinesses
aptnesses11168993_a_ptnesses
blindnesses1446183blindnesses
bluntnesses1345393bluntnesses
braininesses1446553braininesses
brininesses1338983brininesses
canninesses1368853canninesses
canonesses1238423ca_nonesses
daftnesses1436383da_ftnesses
dailinesses1249493dailinesses
dailynesses1543943dailynesses
danknesses1536253da_nknesses
daringnesses1464833daringnesses
facilenesses1756723facilenesses
fadednesses16126563fadednesses
faintishnesses2053303faintishnesses
falsenesses1446743falsenesses
fancinesses1638143fancinesses
farnesses122310813fa__rnesses
fatalnesses1456283fatalnesses
fattinesses14118973fattinesses
faultinesses1545183faultinesses
feistinesses1555893feistinesses
finesses111912343f_i__nesses
finitenesses1557723f_initenesses
firmnesses1535613f_irmnesses
firstnesses1445733firstnesses
flatnesses1337763f_latnesses
fleetnesses1445483fleetnesses
fondnesses1437703f_ondnesses
frailnesses1447593frai_lnesses
franknesses1845603franknesses
funninesses14106873funninesses
gastnesses11129143ga_stnesses
giantesses1143513giant_esses
graininesses1346593graininesses
hairinesses14198943hairinesses
jauntinesses1944683jauntinesses
jointresses1843473jointresses
kindnesses1537213_kindnesses
lanknesses1437503la_nknesses
moistnesses1347153moistnesses
naivenesses1449113naivenesses
pastnesses12910513pa_stnesses
patnesses111611793pa__tnesses
pinknesses1636583_pinknesses
plainnesses1356203plain_nesses
pliantnesses1444453pliantnesses
quietnesses2045603quietnesses
ranknesses1438093ra_nknesses
raptnesses1248523ra_ptnesses
saintlinesses1344363saintlinesses
saltnesses10310163sa_ltnesses
sanenesses10412693sa_nenesses
scantnesses1376533scantnesses
shininesses1448293shininesses
spininesses1358453spininesses
swiftnesses1744503swiftnesses
tacitnesses1336323tacitnesses
tartnesses101110713ta_rtnesses
tautnesses10118283ta_utnesses
tawninesses1436153tawninesses
thingnesses1545193thingnesses
thinnesses1346263thin_nesses
tininesses10311163_tininesses
vacantnesses1742973vacantnesses
valiantnesses1652723valiantnesses
vastnesses13128203va_stnesses
waitresses1345063wai_tresses
wannesses1239233wa_n_nesses
whininesses1746183whininesses
witnesses12219923_wi_tnesses
zaninesses19310383za_ninesses

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 Filter1786911216330.390458182.1
2DLD Change Limit121633864.61026384.6
3Display Results86860.0461869.6
 (SQL Overall)178691865.04635412.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.