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

118 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
costliest113856(None) 
coaliest10316222co_aliest
comeliest13410032comeliest
cosiest93819852cos__iest
costless10310002costl_ess
costlier1038522costlie_r
costliness1245982costliness
courtliest1244892courtliest
couthiest1439402couthiest
ghostliest1453712ghostliest
motliest10310772mo_tliest
portliest11310182portliest
auntliest936313auntliest
beastliest1244663beastliest
boskiest14289733bos_kiest
bossiest103112213bos_siest
bristliest1245143bristliest
bustiest102815053bust_iest
castles94917733castl_es_
cattiest103016333c_attiest
chattiest1448203chattiest
chestiest1438313chest_iest
chilliest14358913chilliest
coastlines12125323coastlines_
coatless1039693coatl_ess
coattest1038853coat_test
cobbiest14118523co_bbiest
cockiest163013293co_ckiest
coldest102514753co__ldest
colies84837053co__lies_
collies94326583co_llies_
comfiest1539133co_mfiest
complies14314523complies_
contest93523233cont__est
coolest9318643co_ol_est
coolies93824963co_olies_
cooties93725733coot_ies_
corkiest143114793co_rkiest
corniest102117303co_rniest
cosies84932153cos__ies_
cosmist11311333cos_mi_st
costumes1258013costumes_
couldest1148353co_uldest
couthest13312083cout_hest
cowiest123614673co__wiest
coziest184014353co__ziest
crawliest14187403crawliest
crustiest112410043crust_iest
cuddliest1343323cuddliest
curliest102713113c_urliest
cushiest133411043cus_hiest
dotiest83717453do_t_iest
dottiest92611393do_ttiest
dustiest93015073dust_iest
featliest1238363featliest
footiest113514913foot_iest
frostiest1239213frost_iest
fustiest113014573fust_iest
ghastliest1443443ghastliest
ghostiest1336543ghost_iest
godliest1039453go_dliest
goggliest1234063goggliest
goodliest1146393goodliest
goutiest93013883gout_iest
gristliest1154983gristliest
gustiest92914523gust_iest
hastiest112916493hast_iest
holiest104319623ho__liest
homeliest1448553homeliest
hootiest113115643hoot_iest
hostiles11312213hostiles_
jolliest152910363jo_lliest
joltiest15249403jolt_iest
jostles143411143jostl_es_
jowliest18247623jo_wliest
loftiest1139083loft_iest
loneliest949443loneliest
lordliest1036103lordliest
loudliest1035763loudliest
loveliest1246973loveliest
lowliest11229473lo_wliest
lustiest82914493lust_iest
mistiest103018313mist_iest
mossiest103112443mos_siest
mostest9314793most__est
mothiest13311033mo_thiest
mouthiest1438363mouthiest
mustiest103017533must_iest
nastiest83615953nast_iest
nettliest945403nettliest
nosiest73415673nos__iest
oiliest72817683_o_iliest
outlies72421993_outlies_
pastiest103319543past_iest
pestiest103018413pest_iest
posties93128813post_ies_
posttest10410233post_test
pottiest102815973po_ttiest
poutiest103016793pout_iest
roiliest8312283ro_iliest
rootiest83115593root_iest
rosiest73919213ros__iest
rustiest83116803rust_iest
sliest66621943__s_liest
sootiest84016753soot_iest
tastiest83216633tast_iest
testiest82715223test_iest
thistliest1344383thistliest
toastiest937423toast_iest
toothiest1237523toothiest
vastiest112713073vast_iest
wiseliest1237723wiseliest
wobbliest16275333wobbliest
wooliest113011643wo_oliest
woolliest1235853woolliest
worthiest1538323worthiest
zestiest173011103zest_iest
zootiest173311213zoot_iest

Search took 10 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.1731032896.0
2DLD Change Limit1486411189.14016262.7
3Display Results1181180.0631873.0
 (SQL Overall)1786911189.37619058.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.