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

100 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
beefinesses167595(None) 
beerinesses1398921beerinesses
beadinesses1449562beadinesses
beefiness1435582beefine_s_s
breezinesses2343942breezinesses
eerinesses10612602_eerinesses
geekinesses1635812geekinesses
leafinesses1437872leafinesses
leerinesses11119482leerinesses
needinesses1258102needinesses
reedinesses1259562reedinesses
seedinesses1259202seedinesses
weedinesses1557072weedinesses
weepinesses1646132weepinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
beeriness1137863beerine_s_s
bittinesses13148263bittinesses
bleaknesses1744033bleaknesses
blearinesses1446543blearinesses
blowinesses1635983blowinesses
bluffnesses1942773bluffnesses
bogginesses1555673bogginesses
boninesses121111453b_oninesses
bonninesses1337353bonninesses
boozinesses22175803boozinesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
boxinesses19127903b_oxinesses
briefnesses1644943brief_nesses
brininesses1339003brininesses
bugginesses1545373bugginesses
bulginesses1466133bulginesses
bulkinesses1786483bulkinesses
bumpinesses17126373bumpinesses
burlinesses1338403burlinesses
bushinesses16107473bushinesses
businesses121411393b_usinesses
bustinesses131310103bustinesses
cheekinesses2164203cheekinesses
cheerinesses1765823cheerinesses
cheesinesses1765373cheesinesses
chewinesses1945143chewinesses
comfinesses1846913comfinesses
creepinesses1645253creepinesses
daffinesses1834843daffinesses
deafnesses1436223deaf_nesses
deepnesses1366673dee_pnesses
deftnesses1436813_deftnesses
dewinesses1438353_dewinesses
easinesses10314443_easinesses
edginesses1236703_edginesses
fierinesses1439243fierinesses
finesses111912343___finesses
gemminesses1634983gemminesses
germinesses1437883germinesses
goofinesses1535963goofinesses
greedinesses1446473greedinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
huffinesses2034123huffinesses
iffinesses1635583_iffinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
keennesses1445323kee_nnesses
leakinesses1538473leakinesses
legginesses1345293legginesses
mealinesses13310973mealinesses
meatinesses13311983meatinesses
meeknesses1644803mee_knesses
meetnesses1237453mee_tnesses
merrinesses1358263merrinesses
messinesses1297513messinesses
miffinesses1944363miffinesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
newsinesses1436323newsinesses
peppinesses1435313peppinesses
perkinesses1748933perkinesses
peskinesses1746573peskinesses
pettinesses1338633pettinesses
puffinesses1934513puffinesses
readinesses12611273readinesses
seaminesses13310753seaminesses
seemlinesses1445223seemlinesses
selfnesses1335893self_nesses
sexinesses1739213_sexinesses
sleepinesses1445673sleepinesses
speedinesses1545593speedinesses
steelinesses1246723steelinesses
tearinesses11311693tearinesses
testinesses111210323testinesses
tweedinesses1643613tweedinesses
wearinesses14310213wearinesses
wheezinesses2742873wheezinesses

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 Limit1216331004.87624945.2
3Display Results1001000.0761315.8
 (SQL Overall)1786911005.34233450.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.