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

129 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
daffinesses183484(None) 
daffiness1634842daffine_s_s
daftnesses1436382da_ftnesses
dailinesses1249492dailinesses
draftinesses1645752draftinesses
huffinesses2034122huffinesses
iffinesses1635582_iffinesses
miffinesses1944362miffinesses
puffinesses1934512puffinesses
achinesses1539303_achinesses
airinesses102613613_airinesses
artinesses10815213_artinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
beefinesses1675953beefinesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
campinesses1737113campinesses
canninesses1368853canninesses
cattinesses13129703cattinesses
comfinesses1846913comfinesses
craftinesses1746383craftinesses
dailynesses1543943dailynesses
daintinesses1346243daintinesses
dampnesses1535603da_mpnesses
danknesses1536253da_nknesses
darknesses1537013da_rknesses
datednesses1357903datednesses
dazednesses2245153dazednesses
deadlinesses1446223deadlinesses
deafnesses1436223deaf_nesses
deftnesses1436813d_eftnesses
dewinesses1438353d_ewinesses
dinginesses1337473dinginesses
dippinesses1635243dippinesses
dirtinesses1239883dirtinesses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
dizzinesses20124023dizzinesses
dodginesses1435433dodginesses
dopinesses13159723d_opinesses
dorkinesses1647663dorkinesses
dottinesses1238133dottinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168633d_ozinesses
dumpinesses16126253dumpinesses
duskinesses16136843duskinesses
dustinesses121110353dustinesses
dwarfnesses1843293dwarf_nesses
earlinesses11311043earlinesses
easinesses10314443ea_sinesses
fancinesses1638143fancinesses
fattinesses14118973fattinesses
finesses111912343___finesses
fluffinesses1742663fluffinesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
goofinesses1535963goofinesses
hairinesses14198943hairinesses
halfnesses1636263half_nesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110223hardinesses
hastinesses141210693hastinesses
hazinesses2239223ha_zinesses
heftinesses1737133heftinesses
jazzinesses2633373jazzinesses
lacinesses12312123la_cinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
leafinesses1437873leafinesses
loftinesses1437923loftinesses
maltinesses13310233maltinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
nappinesses1555923nappinesses
nastinesses111110743nastinesses
nattinesses11119323nattinesses
niftinesses1437243niftinesses
pastinesses13911713pastinesses
pawkinesses2036153pawkinesses
racinesses12313513ra_cinesses
raffinoses1652083raffin_oses
raffishnesses2243223raffishnesses
raininesses11310483raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
raspinesses1338013raspinesses
safenesses1349373sa_fenesses
saltinesses11311453saltinesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
sniffinesses1843693sniffinesses
spiffinesses2043013spiffinesses
stuffinesses1843293stuffinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tanginesses1278883tanginesses
tardinesses121110253tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503tartinesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawninesses1436153tawninesses
wackinesses2036653wackinesses
warinesses131514523wa_rinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
zaninesses19310383za_ninesses

Search took 5 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 Limit1216331294.45327314.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911294.90636423.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.