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

150 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
ghostiest133654(None) 
ghostliest1453711ghostliest
chestiest1438312chestiest
frostiest1239212frostiest
ghastliest1443442ghastliest
ghostier1235382ghostie_r
glossiest10277942glossiest
goosiest92911822goos_iest
goutiest93013882g_outiest
grottiest10147182grottiest
groutiest10147762groutiest
gustiest92914522g_ustiest
hastiest112916502_hastiest
hootiest113115642_hootiest
bhisties1339003bhisties_
blastiest111710053blastiest
blottiest11286833blottiest
boskiest14289733_boskiest
bossiest103112213_bossiest
bustiest102815053_bustiest
chastest1349703chast_est
chattiest1448213chattiest
chertiest1438793chertiest
chokiest1738723cho_kiest
choosiest1437323choosiest
choppiest18226383choppiest
cosiest93819853_cos_iest
costliest1138563_costliest
crustiest112410053crustiest
dhooties1237643dhooties_
dotiest83717453_do_tiest
dottiest92611393_dottiest
drossiest1036523drossiest
dustiest93015073_dustiest
feistiest1237073feistiest
floatiest1237293floatiest
flossiest12296803flossiest
footiest113514913_footiest
frowstiest1643083frowstiest
fustiest113014573_fustiest
gassiest93212523g_assiest
ghosted1236273ghost_e_d
ghosting1336463ghosti_ng
ghostings1433483ghostings
ghostlier1343343ghostlie_r
ghostliness1542563ghostliness
ghosts10489273ghost__s_
ghoulies1235393ghoulies_
glassiest10279253glassiest
gleetiest1035913gleetiest
glintiest1037623glintiest
globbiest1444023globbiest
gloomiest1235603gloomiest
gloppiest1444833gloppiest
glossies93311253glossies_
gnattiest1035383gnattiest
gnostics1146323gnostics_
godliest1039453g_odliest
goodliest1146393goodliest
goofiest12289393g_oofiest
gooiest82813883g_o_oiest
gooniest93213003g_ooniest
goopiest112710553g_oopiest
goriest82218743g_o_riest
gorsiest92511133g_orsiest
grassiest10309513grassiest
grisliest1047353grisliest
gristliest1154983gristliest
grittiest10176983grittiest
grodiest10310553gro_diest
groggiest1235093groggiest
grooviest1334083grooviest
grossest93810093gros_sest
growliest1335583growliest
growthiest1742883growthiest
guiltiest1035713guiltiest
gushiest123510983g_ushiest
gutsiest92610583guts_iest
guttiest92311223g_uttiest
heftiest1439183_heftiest
hissiest112911093_hissiest
hoariest11312883_hoariest
hogties112813993_hogties_
hokiest144114243_ho_kiest
holiest104319623_ho_liest
homiest124116633_ho_miest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hoppiest152610733_hoppiest
horniest112814043_horniest
horsiest112513263_horsiest
hostess103210243_host_ess
hostiles11312213_hostiles_
hottest10411383_ho_ttest
hotties103016963_hotties_
huskiest153210413_huskiest
joltiest15249403_joltiest
knottiest13174563knottiest
loftiest1139083_loftiest
lustiest82914493_lustiest
mistiest103018313_mistiest
mossiest103112443_mossiest
mostest9314793_most_est
mustiest103017533_mustiest
nastiest83615953_nastiest
nosiest73415673_nos_iest
pastiest103319553_pastiest
pestiest103018413_pestiest
phoniest132811543pho_niest
plottiest11287833plottiest
posties93128813_posties_
posttest10410233_posttest
pottiest102815973_pottiest
poutiest103016793_poutiest
prosiest10416523pros_iest
prosties101421193prosties_
rootiest83115593_rootiest
rosiest73919213_ros_iest
rustiest83116803_rustiest
shiftiest1537373shiftiest
shirtiest1239333shirtiest
shittiest1238343shittiest
shoaliest1238513shoaliest
shoddiest1434763shoddiest
shortest11310783short_est
shorties11414583shorties_
showiest1438793sho_wiest
sloshiest1246683sloshiest
snootiest9178753snootiest
snottiest9167973snottiest
snoutiest9178253snoutiest
sootiest84016753_sootiest
sportiest111711033sportiest
spottiest11177693spottiest
tastiest83216633_tastiest
testiest82715223_testiest
thirstiest1343973thirstiest
thistliest1344383thistliest
thorniest1236483thorniest
throatiest1344953throatiest
toastiest937423toastiest
troutiest9127803troutiest
trustiest9239083trustiest
twistiest1235433twistiest
vastiest112713073_vastiest
whitiest14259883wh_itiest
wristiest1237753wristiest
yeastiest1237203yeastiest
zestiest173011103_zestiest
zootiest173311213_zootiest

Search took 9 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.440406115.9
2DLD Change Limit1486411507.86018911.1
3Display Results1501500.0602500.0
 (SQL Overall)1786911508.36021374.5
 
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.