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

388 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
ghosting133646(None) 
ghostings1433481ghostings
hosting114318381_hosting
boosting113311052boosting
cohosting1546322cohosting
costing104323022_costing
frosting12311182frosting
gasting95022762g_asting
ghostier1235382ghostier
gloating102611462gloating
glossing10278882glossing
glouting10379692glouting
goosing93314082goos_ing
gosling93312402g_osling
grossing103111062grossing
grouting103410792grouting
guesting1058462guesting
gusting93917162g_usting
hasting114725192_hasting
histing113720372_histing
hoisting123610902_hoisting
hooting113919882_hooting
hosing103421102_hos_ing
hotting113116522_hotting
posting105622242_posting
roosting93411462roosting
shooting122812862shooting
shorting122514802shorting
shotting123012382shotting
shouting122711792shouting
whisting15329542whisting
aborting11710253aborting
accosting1446733accosting
adopting1237453adopting
agisting1038243agisting
basting104227203_basting
besting104923923_besting
blasting114013433blasting
bloating113512813bloating
blotting113910433blotting
boasting113512503boasting
boating103721303_boating
bolting104416763_bolting
booting103821363_booting
bossing103714603_bossing
bursting1138703bursting
busting104221793_busting
casting104628343_casting
chanting143413533chanting
charting142614193charting
chasing133715893chas_ing
chatting142810143chatting
cheating144014523cheating
chocking204011013chocking
choiring14279793choiring
choking173911943cho_king
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
choring133617663cho_ring
chortling1535563chortling
chousing14259423chousing
chowing164412773cho_wing
chowsing17217343chowsing
chuting132910733ch_uting
closeting1236183closeting
closing103114843clos_ing
clotting113110643clotting
clouting113011683clouting
coasting113615513coasting
coating103525313_coating
coopting133411313coopting
coshing134316433_coshing
cosying134513133_cosying
coting94629253_co_ting
cresting114017043cresting
crossing112612683crossing
crostini1038293crostini
crostino1038883crostino
crusting113612793crusting
dehorting1447213dehorting
doating93816863_doating
dosing83920273_dos_ing
dossing93313273_dossing
doting84821913_do_ting
dotting93314483_dotting
dusting93618993_dusting
easting84924303_easting
egesting1039013egesting
emoting10313563emo_ting
exhorting2045733exhorting
existing1639073existing
fasting114522833_fasting
feasting122011323feasting
fisting113818123_fisting
floating123111883floating
flossing12247903flossing
flouting122610473flouting
foisting122910503foisting
footing115017593_footing
fronting12310443fronting
frostings1335733frostings
frowsting1634683frowsting
gaiting93716583g_aiting
gaoling93314653gao_ling
garoting10510703garoting
garotting1136103garotting
gashing125119233g_ashing
gasking134415913g_asking
gasping113714363g_asping
gassing94216333g_assing
gating84826953g__ating
gavotting1443193gavotting
gelating103015733gelating
getting93316563g_etting
ghettoing1442123ghettoing
ghost96318763ghost___
ghosted1236273ghost_ed
ghostiest1336543ghostiest
ghostlier1343343ghostlier
ghostlike1743353ghostlike
ghostly14355103ghost_ly
ghosts10489273ghost__s
ghosty13467213ghost__y
gifting123810893g_ifting
gipsying1533373gipsying
girting93113333g_irting
gitting93215703g_itting
glassing10329973glassing
gleeting10279173gleeting
glinting103210053glinting
gloaming12268013gloaming
globing113210003glo_bing
glomming14275923glomming
glooming12358013glooming
glopping14307753glopping
glorying1335543glorying
glossina9275543glossina
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
glutting10247643glutting
gnashing1336423gnashing
gnostic1038433gnosti_c
gnostics1146323gnostics
goading103112853g_oading
goaling93515333g_oaling
gobbing132910703g_obbing
godding113911943g_odding
godling103513403g_odling
going75218493g_o__ing
golfing12368943g_olfing
gonging103713033g_onging
goofing123510633g_oofing
gorging102611363g_orging
goring84119573g_o_ring
gorming112810833g_orming
goslings10297553g_oslings
gouging103410703g_ouging
gowning12258833g_owning
grafting13319623grafting
granting103514523granting
grasping12348833grasping
grassing103311973grassing
grating93923183g_rating
greeting103112353greeting
grifting13299263grifting
gritting10309983gritting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grouping12308533grouping
grousing103410453grousing
growing123512473gro_wing
growling1348163growling
grunting10269583grunting
guessing1036243guessing
guising93511413guis_ing
gushing124014223g_ushing
gusseting1173963gusseting
gussying1334063gussying
gutting93415923g_utting
gypsying1842183gypsying
gyrating1337453gyrating
hafting144014173_hafting
halting114419073_halting
hanting114124483_hanting
hashing145020163_hashing
hasping134414903_hasping
hating104929713_h_ating
hatting113920233_hatting
heating114024323_heating
hefting144510913_hefting
heisting123411043heisting
henting113719653_henting
hilting113316893_hilting
hinting113919223_hinting
hissing114213143_hissing
hitting113017273_hitting
hoaxing18307763_hoaxing
hobbing152811123_hobbing
hoboing13309453_hoboing
hocking173417243_hocking
hoeing104117023_ho_eing
hogging133112803_hogging
hogtying1633553_hogtying
hoising113414413_hoising
hoking144419513_ho_king
holding123514283_holding
holing104025073_ho_ling
holking153512313_holking
homing123718383_ho_ming
honing103421503_ho_ning
honking153414793_honking
hooding123815203_hooding
hoofing143912553_hoofing
hooking153716693_hooking
hooping133615703_hooping
hoping123719743_ho_ping
hopping154115273_hopping
hording123517053_hording
horning113015003_horning
horsing113215583_horsing
hoseying1537193_hoseying
hosteling1337893_hosteling
hostile10312553_hostile
housing113316523_housing
howking183610313_howking
howling143413163_howling
hunting114317123_hunting
hurting113914033_hurting
hushing144514473_hushing
husking154312053_husking
hustings12378683_hustings
hustling12228793_hustling
hutting113016033_hutting
imposting1436813imposting
jesting154317713_jesting
joisting16328503joisting
jolting153410913_jolting
joshing18519413_joshing
jostling16207123_jostling
jotting152912773_jotting
jousting16309353jousting
justing153615163_justing
knotting13236573knotting
knouting13226793knouting
lasting84725243_lasting
listing84020593_listing
lofting113311313_lofting
loosing83515963loos_ing
looting83019643_looting
losing74022873_los_ing
lotting82917753_lotting
louting83719383_louting
lusting83619323_lusting
masting104325823_masting
misting103623383_misting
moating104218153_moating
molting103517173_molting
mooting103019363_mooting
moshing134214883_moshing
mossing103915423_mossing
musting103221073_musting
nesting84320443_nesting
noosing83315053noos_ing
noshing114612773_noshing
nosing73419843_nos_ing
noting74120153_no_ting
opting94514403__opting
ousting84021353_ousting
outing74128153__outing
pasting103826553_pasting
phasing133211673phas_ing
phonating1537813phonating
phoning13312053pho_ning
phonying1745833phonying
photoing1439073photoing
plotting113011013plotting
porting103021783_porting
posing93922643_pos_ing
positing11312303_positing
postin83521033_postin_
postings112912303_postings
postins93721203_postins
potting103720893_potting
pouting103519943_pouting
prosing103319383pros_ing
questing1838273questing
quoiting1836093quoiting
quoting17310043quo_ting
reesting93118273reesting
resting85031183_resting
rioting82716393rio_ting
riposting1236063riposting
roasting93012703roasting
roosing84018133roos_ing
rooting83522433_rooting
rosing73925593_ros_ing
rotting82919683_rotting
rousting93913273rousting
routing83821093_routing
rusting83821263_rusting
scooting113012643scooting
scouting112612753scouting
shafting15278683shafting
sheeting122712833sheeting
shifting152910383shifting
shirting123213613shirting
shitting123212663shitting
shoaling123111753shoaling
shocking184311543shocking
shoeing113211883sho_eing
shoestring1444173shoestring
shogging14308023shogging
shooing112112913sho_oing
shooling123012563shooling
shootings13266063shootings
shopping163611293shopping
shoring112820073sho_ring
shoving142910643sho_ving
showing143814663sho_wing
showring1548323showring
shunting123610433shunting
shushing15317743shushing
shuting113212053sh_uting
shutting12309693shutting
sloshing12258823sloshing
slotting92612613slotting
snooting92813203snooting
snorting92613373snorting
snouting92511923snouting
sooting82820963_sooting
sorting83221813_sorting
sporting112415463sporting
spotting112812093spotting
spouting113511953spouting
sting65330243___sting
stotting92811163stotting
swotting12268483swotting
tasting84624213_tasting
testing86021053_testing
thirsting1335283thirsting
tholing112812333tho_ling
thorning1237513thorning
thouing11258603tho_uing
throating1398403throating
thrusting1335013thrusting
toasting93410583toasting
toiting83217093_toiting
tooting83019423_tooting
tossing83612563_tossing
toting74123793_to_ting
totting82816843_totting
touting84118453_touting
trotting92510913trotting
trusting93411653trusting
trysting12267053trysting
twisting12427813twisting
vesting114618683_vesting
voting103916033_vo_ting
waisting123615213waisting
wasting114422843_wasting
westing115020273_westing
whetting1535973whetting
whishing18287183whishing
whishting1983563whishting
whisking19286613whisking
whistling1644733whistling
whiting143311303wh_iting
whomping19285943whomping
whoofing18234833whoofing
whooping17286633whooping
whooshing1943213whooshing
whopping19357373whopping
whoring142910293who_ring
wisting113519743_wisting
wonting113214103_wonting
wooshing1536683wooshing
worsting1267683worsting
wotting112913843_wotting
wresting123811833wresting
yeasting12188923yeasting
zesting174515333_zesting

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 Limit1461623886.84621350.0
3Display Results3883880.1532535.9
 (SQL Overall)1786913887.43524033.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.