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

215 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
hongs9512620(None) 
bongs87828421bongs
dongs76525811dongs
gongs74921611gongs
hangs95726721hangs
hoggs107212461hoggs
hogs87139661ho_gs
hones88144491hones
hong85833951hong_
hongi96715851hongi
honks125124521honks
hons77350781hon_s
longs65527061longs
pongs85526341pongs
songs67725551songs
thongs104611181thongs
tongs65928461tongs
bangs85627772bangs
bhangs12449662bhangs
bogs75742752bo_gs
boings96416872boings
bonds86126842bonds
bones76446532bones
bong75633412bong_
bongo85720942bongo
bongos95316652bongos
bonks116326462bonks
bonus75324322bonus
bungs85323862bungs
changs125215372changs
cogs77340032co_gs
cones76457422cones
conga85419872conga
congas94417032congas
conge85227592conge
conges94928172conges
congo85623132congo
congos94219882congos
conks115525702conks
conns75024232conns
cons66057692con_s
conus76726532conus
dangs75623202dangs
dings76331402dings
dogs66440152do_gs
doings84913182doings
donas65926472donas
dong66031652dong_
donga76718422donga
dongas84914612dongas
dons56048702don_s
dungs75821972dungs
engs56121392_engs
eons46638712eon_s
fangs96224072fangs
flongs105010492flongs
fogs87035002fo_gs
fonds95824822fonds
fons76943892fon_s
fonts86124752fonts
gangs76222572gangs
goings84911522goings
gong66827192gong_
hags86740842h_ags
hands95327382hands
hang85535542hang_
hanks126226862hanks
hants86335402hants
henge94819822henge
henges104516452henges
hens75642572hen_s
hents87330742hents
hinds96721472hinds
hinge95323442hinge
hinges105121022hinges
hins76447992hin_s
hints87330622hints
hoagy124710472hoagy
hoars85925542hoars
hobos106321352hobos
hobs97038982ho_bs
hocks144925492hocks
hocus104715202hocus
hods87239862ho_ds
hoers85724922hoers
hoes75755732ho_es
hog78049062ho_g_
hogg96617532ho_gg
hokes126231642hokes
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292ho_ls
holts85627912holts
homes106938812homes
homos105921782homos
hon67759382hon__
honan85319772honan
honans94814502honans
honda9414982honda
hondas10313352hondas
hone77549322hon_e
honed95332262honed
honer85332092honer
honers94324972honers
honest94822422honest
honey115629912honey
honeys124016082honeys
hongies112716472hongies
honk116931192hon_k
honky156218522honky
honor85718622honor
honors94816792honors
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830242hoots
hopes105835642hopes
hops97942632ho_ps
horas86333092horas
horns86125332horns
hos68364192ho__s
hoses85443172hoses
hosts85526702hosts
hots78349322ho_ts
hounds104413132hounds
hours85422382hours
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoys107733932ho_ys
hugs86129752h_ugs
hung86126352hung_
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
ions46737852ion_s
jogs127129332jo_gs
jones125028182jones
kings105825562kings
klongs11436602klongs
konks84917112konks
lings67135772lings
logs57343112lo_gs
long56933342long_
longe66626462longe
longes75925572longes
lungs65223882lungs
mogs75439332mo_gs
monas74732152monas
mongo810122412mongo
mongos94318622mongos
mongst93512602mongst
monks116123392monks
monos75930862monos
mons68152252mon_s
noggs75811182noggs
nogs56534612no_gs
nonas55126652nonas
nones55639132nones
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onus45826812_onus
pangs84628662pangs
phones114121212phones
phonos114114792phonos
phons105221142phon_s
pings85830882pings
ponds85323402ponds
pones74547042pones
pong76231142pong_
pons65850602pon_s
prongs94314482prongs
pungs85422222pungs
rings65029172rings
rungs611819402rungs
shogs95319702sho_gs
sings65532702sings
snogs66017492snogs
sones55444142sones
song55133672song_
sons46049552son_s
tangs65028342tangs
things104914282things
thong95014172thong_
throngs11508162throngs
tings65329192tings
togs57242432to_gs
tones56048662tones
tong56434352tong_
tonga65619682tonga
tongas74315512tongas
tons46553052ton_s
tonus56324302tonus
tungs65520622tungs
vangs96319582vangs
whangs13439722whangs
wings95727242wings
wogs86531402wo_gs
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
wrongs10338932wrongs
yangs95618692yangs
yonis85020822yonis
youngs1035382youngs
zings154620892zings
zones145528042zones
zonks184815172zonks

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002151.84329191.5
3Display Results2152150.0464673.9
 (SQL Overall)1786912151.98290156.9
 
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.