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 “hosting” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

169 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
hosting11431838(None) 
costing104323021costing
ghosting1336461ghosting
hasting114725191hasting
histing113720371histing
hoisting123610901hoisting
hooting113919881hooting
hosing103421101hos_ing
hotting113116521hotting
posting105622241posting
basting104227202basting
besting104923922besting
boasting113512502boasting
boating103721302boating
bolting104416762bolting
boosting113311052boosting
booting103821362booting
bossing103714602bossing
busting104221792busting
casting104628342casting
coasting113615512coasting
coating103525312coating
cohosting1546322cohosting
coshing134316432coshing
cosying134513132cosying
coting94629252co_ting
doating93816862doating
dosing83920272dos_ing
dossing93313272dossing
doting84821912do_ting
dotting93314482dotting
dusting93618992dusting
easting84924302easting
fasting114522832fasting
fisting113818122fisting
foisting122910502foisting
footing115017592footing
frosting12311182frosting
gasting95022762gasting
ghostings1433482ghostings
gosling93312402gosling
gusting93917162gusting
hafting144014172hafting
halting114419072halting
hanting114124482hanting
hashing145020162hashing
hasping134414902hasping
hating104929712h_ating
hatting113920232hatting
heating114024322heating
hefting144510912hefting
heisting123411042heisting
henting113719652henting
hilting113316892hilting
hinting113919222hinting
hissing114213142hissing
hitting113017272hitting
hoaxing18307762hoaxing
hobbing152811122hobbing
hoboing13309452hoboing
hocking173417242hocking
hoeing104117022ho_eing
hogging133112802hogging
hogtying1633552hogtying
hoising113414412hoising
hoking144419512ho_king
holding123514282holding
holing104025072ho_ling
holking153512312holking
homing123718382ho_ming
honing103421502ho_ning
honking153414792honking
hooding123815202hooding
hoofing143912552hoofing
hooking153716692hooking
hooping133615702hooping
hoping123719742ho_ping
hopping154115272hopping
hording123517052hording
horning113015002horning
horsing113215582horsing
hoseying1537192hoseying
hosteling1337892hosteling
hostile10312552hostile
housing113316522housing
howking183610312howking
howling143413162howling
hunting114317122hunting
hurting113914032hurting
hushing144514472hushing
husking154312052husking
hustings12378682hustings
hustling12228792hustling
hutting113016032hutting
jesting154317712jesting
joisting16328502joisting
jolting153410912jolting
joshing18519412joshing
jostling16207122jostling
jotting152912772jotting
jousting16309352jousting
justing153615162justing
lasting84725242lasting
listing84020592listing
lofting113311312lofting
looting83019642looting
losing74022872los_ing
lotting82917752lotting
louting83719382louting
lusting83619322lusting
masting104325822masting
misting103623382misting
moating104218152moating
molting103517172molting
mooting103019362mooting
moshing134214882moshing
mossing103915422mossing
musting103221072musting
nesting84320442nesting
noshing114612772noshing
nosing73419842nos_ing
noting74120152no_ting
opting94514402_opting
ousting84021352ousting
outing74128152_outing
pasting103826552pasting
porting103021782porting
posing93922642pos_ing
positing11312302positing
postin83521032postin_
postings112912302postings
postins93721202postins
potting103720892potting
pouting103519942pouting
resting85031182resting
roasting93012702roasting
roosting93411462roosting
rooting83522432rooting
rosing73925592ros_ing
rotting82919682rotting
rousting93913272rousting
routing83821092routing
rusting83821262rusting
shooting122812862shooting
shorting122514802shorting
shotting123012382shotting
shouting122711792shouting
sooting82820962sooting
sorting83221812sorting
sting65330242__sting
tasting84624212tasting
testing86021052testing
toasting93410582toasting
toiting83217092toiting
tooting83019422tooting
tossing83612562tossing
toting74123792to_ting
totting82816842totting
touting84118452touting
vesting114618682vesting
voting103916032vo_ting
wasting114422842wasting
westing115020272westing
whisting15329542whisting
wisting113519742wisting
wonting113214102wonting
worsting1267682worsting
wotting112913842wotting
zesting174515332zesting

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711692.89037256.4
3Display Results1691690.0632682.5
 (SQL Overall)1786911693.32953677.1
 
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.