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

208 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
ghostier123538(None) 
ghostlier1343341ghostlier
chestier1387422chestier
frostier1148162frostier
ghastlier1342892ghastlier
ghosted1236272ghost_ed
ghostiest1336542ghostiest
ghosting1336462ghosting
glossier9358202glossier
goosier83512562goos_ier
goutier82612352g_outier
grottier9316672grottier
groutier9297172groutier
gustier83813862g_ustier
hastier103916622_hastier
hootier104915352_hootier
hosier94219612_hos_ier
hostler103411022_hostler
bhistie1236773bhistie_
bhisties1339003bhisties
blastier10249493blastier
blottier10336413blottier
booster94314553boost_er
boskier13309173_boskier
bossier93712423_bossier
bustier93916153_bustier
chaster124718503chast_er
chastiser1444373chastiser
chattier1337513chattier
chertier1387873chertier
chokier1638043cho_kier
choosier1337173choosier
choppier17286643choppier
chortler13336843chortler
cosier84423753_cos_ier
coster84331293_cost_er
costlier1038523_costlier
cottier93814173_cottier
crosier94116573cros_ier
crustier10259533crustier
dhootie1136473dhootie_
dhooties1237643dhooties
dossier83711693_dossier
dotier73917033_do_tier
dottier83910923_dottier
drossier956313drossier
dustier83814133_dustier
feistier1136193feistier
floatier1136983floatier
flossier11326973flossier
footier104115113_footier
foster94322223_fost_er
frontier1147313frontier
frowstier1553143frowstier
fustier104213933_fustier
gagster9317633gagst_er
gasolier935833gasolier
gassier83812573g_assier
gaster75027353g_ast_er
ghost96318763ghost___
ghostings1433483ghostings
ghostliest1453713ghostliest
ghostlike1743353ghostlike
ghostly14355103ghost_ly
ghosts10489273ghost__s
ghostwriter1851513ghostwriter
ghosty13467213ghost__y
ghoulie1144263ghoulie_
ghoulies1235393ghoulies
glassier9289083glassier
gleetier934913gleetier
glintier945703glintier
glister84013343glist_er
gloater83711013gloat_er
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glosser83410813glos_ser
glossies93311253glossies
gnattier934263gnattier
gnostic1038433gnosti_c
gnostics1146323gnostics
godlier938893g_odlier
goiter74116203g_oit_er
goodlier1035793goodlier
goofier11339313g_oofier
gooier73516213g_o_oier
goonier83612843g_oonier
goopier103910573g_oopier
gorier73719373g_o_rier
gorsier83811073g_orsier
gossiper1164203g_ossiper
grassier9349283grassier
grislier935793grislier
grister83915413grist_er
gristlier1044283gristlier
grittier9316263grittier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grosser84313143gros_ser
grouter84412523grout_er
growlier1234883growlier
growthier1642203growthier
guiltier934493guiltier
gushier113110073g_ushier
gutsier8389823guts_ier
guttier83911103g_uttier
gypster1333953gypst_er
heftier1337203_heftier
hissier103410503_hissier
hoarier104211743_hoarier
hogtie102711773_hogtie_
hogtied12226653_hogtied
hogties112813993_hogties
hoister103714203_hoist_er
hokier134214033_ho_kier
holier94921623_ho_lier
holster103512213_holst_er
homier116416993_ho_mier
hoodier113812973_hoodier
hookier143811673_hookier
hooter94123933_hoot_er
hoppier143110703_hoppier
hornier103012463_hornier
horsier103013243_horsier
hoser811529763_hos__er
hosiers104212643_hos_iers
hosiery13337183_hos_iery
hosted105020343_host_ed
hostel93914153_host_el
hosteler1137273_hosteler
hostile10312553_hostile
hostiles11312213_hostiles
hosting114318383_hosting
hostlers113310483_hostlers
hotter94720083_ho_tter
hottie92514383_hottie_
hotties103016963_hotties
huskier14369763_huskier
hustler103410753_hustler
joltier14318493_joltier
jostler14288223_jostler
knottier12203983knottier
loftier1037763_loftier
lustier73813503_lustier
mistier93418713_mistier
mossier94413813_mossier
mustier94017963_mustier
nastier74115293_nastier
nosier63716323_nos_ier
osier53518013__os_ier
ostler63312193__ostler
pastier94320383_pastier
pestier94317403_pestier
phonier122710633pho_nier
plottier10327263plottier
poster84129173_post_er
postie84123963_postie_
posties93128813_posties
pottier93516493_pottier
poutier93215323_poutier
prosier93817483pros_ier
prostie91617743prostie_
prosties101421193prosties
rooster74415173roost_er
rootier74915393_rootier
rosier64221263_ros_ier
roster64329083_rost_er
rustier74416363_rustier
shiftier1436343shiftier
shirtier1137943shirtier
shittier1137313shittier
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoot_er
shorter103515503short_er
shortie10411343shortie_
shorties11414583shorties
shouter103213083shout_er
showier1339103sho_wier
shyster13116563shyst_er
sloshier1135283sloshier
snootier8278383snootier
snottier8217383snottier
snoutier8206973snoutier
sootier73916613_sootier
sportier102010053sportier
spottier10207313spottier
tastier711817093_tastier
testier74015643_testier
thirstier1243693thirstier
thistlier1243653thistlier
thornier1135323thornier
throatier1244553throatier
toastier846893toastier
troutier8277153troutier
trustier8268683trustier
twistier1134813twistier
vastier103613203_vastier
whistler1496313whistler
whitier133311063wh_itier
whosever1742893whosever
wristier1136863wristier
yeastier1135393yeastier
zestier163010223_zestier
zootier163611173_zootier
zoster153715853_zost_er

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622086.81321453.4
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.32524394.7
 
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.