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

257 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
longs6552706(None) 
bongs87828421bongs
dongs76525811dongs
flongs105010491flongs
gongs74921611gongs
hongs95126201hongs
klongs11436601klongs
lings67135771lings
logs57343111lo_gs
long56933341long_
longe66626461longe
longes75925571longes
lungs65223881lungs
pongs85526341pongs
songs67725551songs
tongs65928461tongs
along65419492along_
bangs85627772bangs
belongs10408222belongs
blogs85319232blo_gs
blonds95213342blonds
bogs75742752bo_gs
boings96416872boings
bonds86126842bonds
bones76446532bones
bong75633412bong_
bongo85720942bongo
bongos95316652bongos
bonks116326462bonks
bonus75324322bonus
bungs85323862bungs
clangs95113612clangs
clings95716212clings
clogs85519552clo_gs
clones84526562clones
clonks125013472clonks
clons75228132clon_s
clonus85212402clonus
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
flings106715282flings
flogs95919962flo_gs
flong95815682flong_
fogs87035002fo_gs
fonds95824822fonds
fons76943892fon_s
fonts86124752fonts
gangs76222572gangs
gloggs935032gloggs
goings84911522goings
gong66827192gong_
hangs95726722hangs
hoggs107212462hoggs
hogs87139662ho_gs
hones88144492hones
hong85833952hong_
hongi96715852hongi
honks125124522honks
hons77350782hon_s
ions46737852ion_s
jogs127129332jo_gs
jones125028182jones
kalongs1255442kalongs
kings105825562kings
klong105310402klong_
konks84917112konks
lags56546222l_ags
lands65426902lands
lanes54946792lanes
lang56637372lang_
legongs934542legongs
legs56133692l_egs
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leones64417722leones
liangs74410592liangs
lines57054572lines
ling57447962ling_
linga66820812linga
lingas75116562lingas
lingo66022102lingo
lingy96925132lingy
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
lions55923212lion_s
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locos75822602locos
locus74819992locus
lodes66436912lodes
lodge76520082lodge
lodges86820142lodges
loess55714702loess
lofts85518362lofts
log46252682lo_g_
loge56837192lo_ge
loges66534202loges
loggy105714192loggy
logo57931762lo_go
logos67225332logos
logy87025782lo_gy
loids66220702loids
loins56728422loins
lolls512121732lolls
lone45849132lon_e
loner55431032loner
loners64225802loners
longan75612362longan
longans84510812longans
longed87121372longed
longer75823192longer
longers84819532longers
longest84114952longest
longies82916552longies
longish11229092longish
longly10279602longly
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loots55431422loots
lopes76437342lopes
lops66043352lo_ps
lords64923502lords
lores55045402lores
loris55329152loris
loses56742012loses
losings82810622losings
loss45337962lo_ss
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lotus55718062lotus
lough95118482lough
loughs105014772loughs
louis57322322louis
lounge75211212lounge
lounges84811352lounges
loungy10476832loungy
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lowings113710072lowings
lows75843012lo_ws
loxes125227472loxes
lugs55233522l_ugs
lunas55025012lunas
lunes55337772lunes
lung55732492lung_
lunge65323802lunge
lunges76123422lunges
lungi65516052lungi
lungis77113022lungis
lunks94822452lunks
lunts55826902lunts
lyings10488502lyings
mogs75439332mo_gs
monas74732152monas
mongo810122412mongo
mongos94318622mongos
mongst93512602mongst
monks116123392monks
monos75930862monos
mons68152252mon_s
noggs75811182noggs
nogs56534612no_gs
nonas55126652nonas
nones55639132nones
oblongs1033532oblongs
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onus45826812_onus
oolongs845942oolongs
pangs84628662pangs
pings85830882pings
plonks124210412plonks
ponds85323402ponds
pones74547042pones
pong76231142pong_
pons65850602pon_s
prongs94314482prongs
pungs85422222pungs
rings65029172rings
rungs611819402rungs
sings65532702sings
slangs75615342slangs
slings74618012slings
slogs64521842slo_gs
snogs66017492snogs
sones55444142sones
song55133672song_
sons46049552son_s
tangs65028342tangs
thongs104611182thongs
tings65329192tings
togs57242432to_gs
tones56048662tones
tong56434352tong_
tonga65619682tonga
tongas74315512tongas
tons46553052ton_s
tonus56324302tonus
tungs65520622tungs
vangs96319582vangs
wings95727242wings
wogs86531402wo_gs
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
wrongs10338932wrongs
yangs95618692yangs
yonis85020822yonis
youngs1035382youngs
zings154620892zings
zones145528042zones
zonks184815172zonks

Search took 6 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.343520965.0
2DLD Change Limit538002574.73611359.8
3Display Results2572570.2031266.0
 (SQL Overall)1786912575.28233830.2
 
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.