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

116 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
faintness123583(None) 
daintiness1145962daintiness
fainters11349692faint_ers
faintest1139072faint_est
faintnesses1447142faintnesses
fairness1136562fai_rness
fastness11238762fa_stness
fatness103311292fa__tness
fineness11310642f_ineness
fitness10299392f_i_tness
flintiness1345892flintiness
gauntness1044202gauntness
quaintness1943202quaintness
raininess949272raininess
taintless935732taintless
vainness1136062vain_ness
airiness8412213_airiness
aptness9268573_a_ptness
blindness1235343blindness
bluntness1144343bluntness
braininess1246123braininess
brininess1138203brininess
canniness1138643canniness
canoness1039393ca_noness
daftness1235533da_ftness
dailiness1038673dailiness
dailyness1343643dailyness
dainties9312403daintie_s
daintiest1039153daintiest
dankness13256693da_nkness
daringness1244743daringness
dauntless1033663dauntless
facileness1545503facileness
fadedness1445613fadedness
fainest10417703fai__nest
fainted114211723faint_e_d
fainter103611053faint_e_r
faintish1446193faint_ish
faintishness1863063faintishness
faints94818783faint___s
faithless1543903faithless
falseness1236093falseness
fanciness1437673fanciness
fangless1237663fa_ngless
fanners103914653fa_n_ners
farness102912203fa__rness
fatalness1245773fatalness
fatless103212203fa__tless
fattiness12239373fattiness
faultiness1344823faultiness
faultless1243163faultless
feistiness1345073feistiness
finiteness1347113f_initeness
finless102810783f_in_less
firmness1334743f_irmness
firstness1245013firstness
flatness1138153f_latness
fleetness1244753fleetness
flintiest1248433flintiest
fondness1237213f_ondness
frailness1236543frai_lness
frankness1655223frankness
frontless1235403frontless
funniness12256533funniness
gainless9117403gain_less
gastness9278473ga_stness
giantess933893giant_ess
graininess1145793graininess
hairiness1238013hairiness
jauntiness1743973jauntiness
jointless1634323jointless
jointress1643053jointress
kindness13236653_kindness
lankness12237043la_nkness
lintless82710013_lintless
moistness1146343moistness
naiveness1277493naiveness
painless10108343pain_less
painters103013023paint_ers
paintiest11310563paintiest
pastness102510503pa_stness
patness92912283pa__tness
pinkness1436513_pinkness
plainness1155183plain_ness
pliantness1263643pliantness
pointless1135703pointless
printless1137513printless
quietness1844753quietness
rainless8129703rain_less
rankness12267943ra_nkness
raptness1046733ra_ptness
saintliness1144153saintliness
saltness82610243sa_ltness
saneness82313723sa_neness
scantness1135733scantness
shininess1237333shininess
spininess1137963spininess
swiftness1543653swiftness
tacitness1134873tacitness
tartness82210133ta_rtness
tautness8217183ta_utness
tawniness1245123tawniness
thingness1354893thingness
thinness11277163thin_ness
tininess8310633_tininess
tintless8239863_tintless
vacantness1562513vacantness
valiantness1452313valiantness
vastness11257293va_stness
vintners1134573_vintners
waistless1235093waistless
waitress1135223wai_tress
wanness102610683wa_n_ness
whininess1535123whininess
witness103010013_wi_tness
zaniness1738663za_niness

Search took 9 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 Filter1786911486410.440406115.9
2DLD Change Limit1486411167.51319784.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.99922339.2
 
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.