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

75 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
cliffiest174395(None) 
chaffiest2045412chaffiest
chuffiest2044402chuffiest
cliffier1633912cliffie_r
clingiest1257132clingiest
cliquiest2044092cliquiest
fluffiest1434092fluffiest
iffiest1337962__iffiest
miffiest1637132_miffiest
sniffiest15236002sniffiest
spiffiest17235652spiffiest
biffies152710853_biffies_
bluffest1664643bluff_est
buffiest1657563_buffiest
chichiest1936343chichiest
chiefest1645313chief_est
chilliest14358913chilliest
chinkiest1867023chinkiest
chippiest18256803chippiest
chirpiest16286473chirpiest
chuffest1944193chuff_est
clammiest1535733clammiest
clankiest1536663clankiest
classiest11309543classiest
clayiest1337913cl_ayiest
cliffs14477593cliff__s_
cloddiest1334633cloddiest
cloggiest1334723cloggiest
cloudiest1235583cloudiest
clubbiest1534273clubbiest
clumpiest1535343clumpiest
clumsiest1335393clumsiest
clunkiest1535163clunkiest
coiffes1546803coiff_es_
colickiest1843523colickiest
comfiest1539133c_omfiest
craftiest1436913craftiest
crimpiest15237183crimpiest
crispiest13197423crispiest
daffiest1537843_daffiest
draffiest1644363draffiest
driftiest1335943driftiest
flimsiest1434463flimsiest
flintiest1248433flintiest
flirtiest1236193flirtiest
glintiest1037623glintiest
glitziest1944003glitziest
gruffiest1634533gruffiest
huffiest1757203_huffiest
jiffies20327473_jiffies_
leafiest113410883_leafiest
liefest1038443_lief_est
limbiest12258893_limbiest
limiest93716103_li_miest
lingiest93715263_lingiest
liniest73321153_li_niest
lintiest82715913_lintiest
lippiest122310613_lippiest
loftiest1139083_loftiest
niftiest112910073_niftiest
puffiest1647323_puffiest
scruffiest1842933scruffiest
shiftiest1537363shiftiest
slimiest10310743sli_miest
slimsiest1135883slimsiest
slinkiest13188073slinkiest
slippiest1346463slippiest
slittiest938203slittiest
snuffiest15246053snuffiest
spiffies16277993spiffies_
squiffiest2542663squiffiest
stiffest1435683stiff_est
stiffies14258383stiffies_
stuffiest15235953stuffiest
wiftiest14279173_wiftiest

Search took 7 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.436409841.7
2DLD Change Limit148641756.34323433.9
3Display Results75750.0461630.4
 (SQL Overall)178691756.82526181.8
 
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.