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

108 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
rapidnesses147647(None) 
rabidnesses1476131rabidnesses
vapidnesses1774891vapidnesses
acidnesses1337252_acidnesses
aridnesses1139942_aridnesses
avidnesses1436462_avidnesses
grapinesses1438582grapi_nesses
racinesses12313512raci_nesses
rancidnesses1544882rancidnesses
randinesses121311202randinesses
rapidness12155472rapidne_s_s
raptnesses1248522rap_tnesses
raspinesses1338012raspi_nesses
rigidnesses1345922rigidnesses
ropinesses121311022ropi_nesses
tepidnesses1445382tepidnesses
validnesses1576022validnesses
acridnesses1445793acridnesses
agednesses1237413_agednesses
algidnesses1345163algidnesses
apishnesses1646383_apishnesses
aptnesses11168993_ap_tnesses
artinesses10815223arti_nesses
badnesses1239253ba__dnesses
baldnesses1337653ba_ldnesses
bandinesses14109733bandinesses
bawdinesses17126323bawdinesses
caginesses13310943cagi_nesses
cakinesses16310613caki_nesses
campinesses1737113campi_nesses
candidnesses1685393candidnesses
crazinesses2237933crazi_nesses
datednesses1357903datednesses
dazednesses2245153dazednesses
dopinesses13159723dopi_nesses
easinesses10314443easi_nesses
fadednesses16126563fadednesses
fairnesses1357383fa_irnesses
fetidnesses1546653fetidnesses
fluidnesses1545483fluidnesses
frailnesses1447593fra_ilnesses
frigidnesses1743643frigidnesses
gaminesses13410463gami_nesses
gaudinesses1337863gaudinesses
gelidnesses1355983gelidnesses
grandnesses1348113gra_ndnesses
graphicnesses2151843graphicnesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110223hardinesses
hardnesses141810543ha_rdnesses
hazinesses2239223hazi_nesses
humidnesses1744583humidnesses
jadednesses20145773jadednesses
lacinesses12312123laci_nesses
lazinesses19310153lazi_nesses
limpidnesses1743623limpidnesses
lividnesses1545023lividnesses
lucidnesses1445243lucidnesses
luridnesses1246723luridnesses
madnesses1239833ma__dnesses
matinesses12314543mati_nesses
mazednesses2345403mazednesses
mazinesses2139923mazi_nesses
mopinesses14139123mopi_nesses
nakednesses1645843nakednesses
nappinesses1555923nappinesses
pallidnesses1543923pallidnesses
pipinesses1448603pipi_nesses
placidnesses1743953placidnesses
rabidness12145263rabidne_s_s
raggednesses1543863raggednesses
raininesses11310493raininesses
rakishnesses1944993rakishnesses
ranginesses121210113ranginesses
ranknesses1438093ra_nknesses
rarenesses10313113ra_renesses
rashnesses1338723ra_shnesses
rawnesses1288123ra__wnesses
readinesses12611273readi_nesses
rednesses10312313r__ednesses
reedinesses1259563reedinesses
riminesses121211423rimi_nesses
ripenesses12310383rip_enesses
rosinesses101213153rosi_nesses
roundnesses1247043roundnesses
rowdinesses1536963rowdinesses
ruddinesses1336033ruddinesses
sadnesses10310303sa__dnesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
soapinesses1339713soapi_nesses
solidnesses1238103solidnesses
staidnesses1237193staidnesses
stupidnesses1543353stupidnesses
tacitnesses1336323tacitnesses
tardinesses121110253tardinesses
timidnesses1445143timidnesses
tumidnesses1444613tumidnesses
vainnesses1337343va_innesses
vapidness15144423vapidne_s_s
vividnesses1844223vividnesses
voidnesses1436843_voidnesses
warinesses131514523wari_nesses
waspinesses1636703waspi_nesses
wavinesses16199283wavi_nesses
waxinesses20138763waxi_nesses
zaninesses19310383zani_nesses

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 Limit1216331085.19023436.0
3Display Results1081080.0631714.3
 (SQL Overall)1786911085.64331666.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.