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

185 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
lungyi1052509(None) 
lungi65516051lung_i
lungyis11294101lungyis
dungy104713642dungy_
fungi95014132fung_i
lingy96925132lingy_
loungy10476832loungy_
lung55732492lung__
lungan74710212lungan
lunge65323802lung_e
lunged85418272lunged
lungee75119812lungee
lunger75720412lunger
lunges76123422lunges
lungis77113022lungis
lungs65223882lung_s
luny77324132lun_y_
aunty85919813aunty_
blunge94311483blung_e
blunged114310133blunged
blunger104112013blunger
blunges104212223blunges
buggy124613483buggy_
bulgy115214103bulgy_
bung75730633bung__
bunged105218793bunged
bungee96319773bungee
bungle97116113bungle
bungs85323863bung_s
bunny104715803bunny_
bunya103810093bun_ya
clingy12659063clingy_
clung86013603clung__
clunky15447893clunky_
congii957363congii
dingy105721263dingy_
dung66328433dung__
dunged95414693dunged
dungs75821973dung_s
flung95114583flung__
flunky16408093flunky_
fuggy135411673fuggy_
fundi96814913fun_di
fungal10388733fungal
fungic12387813fungic
fungo94413133fung_o
fungoid1245243fungoid
fungus10418183fungus
funky154315133funky_
funny114614833funny_
grungy11345973grungy_
gunky135514113gunky_
gunny94413663gunny_
hongi96715853hong_i
hung86126353hung__
hunger104015203hunger
hungry1334973hungry
hunky155417733hunky_
jungle144012653jungle
jungly17407693jungly
junky194513233junky_
kludgy15294223kludgy_
lanai5319573lan_ai
lang56637373lang__
langue71012173langue
languid936623languid
langur7109303langur
lanky125517483lanky_
laogai735983laogai
ledgy105712013ledgy_
leggy105210243leggy_
length1046103length
lindy96918313lindy_
liney87029623liney_
ling57447963ling__
linga66820813ling_a
lingam95112333lingam
lingas75116563lingas
linger75225993linger
lingo66022103ling_o
lings67135773ling_s
lingua7509903lingua
linky127622383linky_
linty87126563linty_
liny78141323lin_y_
loggy105714193loggy_
logoi69715943l_ogoi
logy87025783l_ogy_
long56933343long__
longan75612363longan
longe66626463long_e
longed87121373longed
longer75823193longer
longes75925573longes
longly10279603longly
longs65527063long_s
lounge75211213loung_e
lounged9468243lounged
lounger84610213lounger
lounges84811353lounges
lucky145515013lucky_
lug46138063lu_g__
luge55531643lu_g_e
luged74019093lu_ged
luger65322083lu_ger
luges65928753lu_ges
lugged94417053lugged
lugger83916553lugger
luggie8318903luggie
lugs55233523lu_g_s
lumpy126615913lumpy_
luna46229853lun__a
lunacy1136843lunacy
lunar57017313lun_ar
lunars65012813lunars
lunas55025013lun_as
lunate6316043lunate
lunatic938753lunatic
lunch104917243lun_ch
lune47140493lun__e
lunes55337773lun_es
lunet56835423lun_et
lunets66914763lunets
lungans8399053lungans
lungees84412143lungees
lungers83817083lungers
lungfish1543963lungfish
lungful1144013lungful
lunging93714213lunging
lunier64617603lunier
lunies64723013lunies
lunk86030723lun__k
lunker104718343lunker
lunks94822453lun_ks
lunt46148843lun__t
lunted74517523lunted
lunts55826903lun_ts
lunula636173lunula
lunule638433lunule
lusty85417573lusty_
mangy115021233mangy_
mingy115520183mingy_
muggy125612373muggy_
mungo84916053mung_o
mungos94311373mungos
muni65824403mun__i
plunge93811053plung_e
plunged11439513plunged
plunger104211233plunger
plunges104011613plunges
plunky15377953plunky_
pudgy124911163pudgy_
puggy124612323puggy_
pung75429633pung__
pungle94413573pungle
pungs85422223pung_s
punji1438203pun_ji
punky144419393punky_
punny104217713punny_
punty106021613punty_
puny95526993pun_y_
rangy95320383rangy_
rung56429973rung__
rungs611819403rung_s
runny84613483runny_
runty86119043runty_
sengi64016513seng_i
slangy105411393slangy_
sludgy11366253sludgy_
slung65117833slung__
sung55832173sung__
sunny84917743sunny_
surgy95118523surgy_
tangy94519933tangy_
tung55328163tung__
tungs65520623tung_s
tunny86515033tunny_
unai44824783_un_ai
unci65019463_un_ci
undy85015163_undy_
ungot61718063_ungot
unguis738443_unguis
vuggy13589483vuggy_
wingy126521033wingy_
zingy186516133zingy_

Search took 10 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161859.05012454.8
3Display Results1851850.1061745.3
 (SQL Overall)1786911859.29619222.4
 
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.