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

206 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
lungs6522388(None) 
bungs85323861bungs
dungs75821971dungs
lings67135771lings
longs65527061longs
lugs55233521lu_gs
lunas55025011lunas
lunes55337771lunes
lung55732491lung_
lunge65323801lunge
lunges76123421lunges
lungi65516051lungi
lungis77113021lungis
lunks94822451lunks
lunts55826901lunts
pungs85422221pungs
rungs611819401rungs
tungs65520621tungs
aunts55227632aunts
bangs85627772bangs
bluings10327962bluings
blunge94311482blunge
blunges104212222blunges
blunts84512892blunts
bongs87828422bongs
bugs76035912bu_gs
bunas75126572bunas
bunds85523542bunds
bung75730632bung_
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
burgs84924092burgs
clangs95113612clangs
clings95716212clings
clung86013602clung_
clunks124811012clunks
cunts76125122cunts
dangs75623202dangs
dings76331402dings
dongs76525812dongs
dugs614832282du_gs
dunes65332172dunes
dung66328432dung_
dungy104713642dungy
dunks105621192dunks
duns55140432dun_s
dunts65828412dunts
engs56121392_engs
fangs96224072fangs
flings106715282flings
flongs105010492flongs
flung95114582flung_
flunks13469862flunks
fugs85730692fu_gs
funds94119252funds
fungi95014132fungi
fungo94413132fungo
fungus10418182fungus
funks125318912funks
funs75235732fun_s
gangs76222572gangs
glugs75214282glu_gs
gongs74921612gongs
gunks104517722gunks
guns55533482gun_s
hangs95726722hangs
hongs95126202hongs
hugs86129752hu_gs
hung86126352hung_
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
jugs125525602ju_gs
junks164815972junks
kings105825562kings
klongs11436602klongs
lags56546222l_ags
lands65426902lands
lanes54946792lanes
lang56637382lang_
legs56133692l_egs
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
liangs74410592liangs
lines57054572lines
ling57447962ling_
linga66820822linga
lingas75116572lingas
lingo66022112lingo
lingy96925142lingy
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
logs57343112l_ogs
long56933342long_
longe66626462longe
longes75925572longes
lounge75211212lounge
lounges84811352lounges
loungy10476832loungy
luaus54514902luaus
lubes74727992lubes
luces75528432luces
lucks115723562lucks
ludes65728852ludes
lues45943552lu_es
luffs114516282luffs
lug46138062lu_g_
luge55531642lu_ge
luges65928752luges
lulls54119652lulls
lulus54315162lulus
lumas75622912lumas
lumps95624982lumps
lums65734242lu_ms
luna46229852lun_a
lunar57017312lunar
lunars65012812lunars
lunch104917242lunch
lune47140492lun_e
lunet56835422lunet
lunets66914762lunets
lungan74710212lungan
lungans8399052lungans
lunged85418272lunged
lungee75119812lungee
lungees84412142lungees
lunger75720422lunger
lungers83817092lungers
lungyi10525092lungyi
lungyis11294102lungyis
lunies64723012lunies
lunk86030722lun_k
lunt46148842lun_t
luny77324132lun_y
lupus74512522lupus
lures56138532lures
lurks95218742lurks
lusts55022802lusts
lusus54813872lusus
lutes55836662lutes
lutings83311052lutings
luvs75818502lu_vs
luxes124921502luxes
lyings10488502lyings
muggs94912322muggs
mugs76232042mu_gs
mungo84916052mungo
mungos94311372mungos
munis75022002munis
muns65535922mun_s
nuns45228232nun_s
pangs84628662pangs
pings85830882pings
plugs85213492plu_gs
plunge93811052plunge
plunges104011612plunges
plunks124711162plunks
pongs85526342pongs
pugs76332772pu_gs
punas74826752punas
pung75429632pung_
punks114822682punks
puns66641482pun_s
punts75828002punts
quags154613252quags
rings65029172rings
rugs56033682ru_gs
runes55530222runes
rung56429982rung_
runs46438082run_s
runts55927632runts
sings65532702sings
slangs75615342slangs
slings74618012slings
slugs64618562slu_gs
slung65117832slung_
snugs64913022snugs
songs67725552songs
sung55832172sung_
sunns55017352sunns
suns45841902sun_s
tangs65028342tangs
tings65329202tings
tongs65928462tongs
tugs56231672tu_gs
tunas54224122tunas
tunes55332192tunes
tung55328162tung_
tuns45138662tun_s
ulnas55716532ulnas
uns35936762_un_s
vangs96319582vangs
vuggs10579132vuggs
vugs87022872vu_gs
wings95727242wings
yangs95618692yangs
youngs1035382youngs
zings154620892zings

Search took 2 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.313570897.8
2DLD Change Limit538002061.43637465.2
3Display Results2062060.0504120.0
 (SQL Overall)1786912061.79999328.0
 
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.