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

112 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
lunies6472301(None) 
lunes55337771lun_es
lunges76123421lunges
lunier64617601lunier
luniest73516991luniest
alunites8310702alunites
aunties73920072aunties
blunges104212222blunges
bunnies94415002bunnies
buries84633272buries
burnies94017822burnies
busies85525262busies
conies84338592conies
curies84934022curies
cuties84927362cuties
denies74729642denies
dunces95215752dunces
dunes65332172dun_es
dunites8313592dunites
duties74921902duties
flunkies1536392flunkies
funnies104113602funnies
furies95126372furies
genies75324942genies
gunites8313122gunites
gunnies83413122gunnies
hunkies143214502hunkies
junkies183711692junkies
juries134120632juries
ladies75124882ladies
lances84824102lances
lanes54946792lan_es
launces9329002launces
lazies154418782lazies
lenes54738522len_es
lenis56326862leni_s
lenites7818442lenites
lenses64620892lenses
levies93919862levies
lies46454192l__ies
lilies63021412lilies
lindies8416582lindies
lines57054572lin_es
linier64423792linier
liniest73321152liniest
linins65922142linins
longes75925572longes
longies82916552longies
looies65025832looies
loonies73919542loonies
lories64933042lories
louies64525102louies
lounges84811352lounges
lubes74727992lu_bes
luces75528432lu_ces
lucites9311862lucites
luckies133313682luckies
lucres84513302lucres
ludes65728852lu_des
lues45943552lu__es
luges65928752lu_ges
luggies93011212luggies
lunacies1038012lunacies
lunars65012812lunars
lunas55025012lun_as
lunches124115442lunches
lune47140492lun_e_
lunet56835422lun_et
lunets66914762lunets
lunge65323802lunge_
lunged85418272lunged
lungee75119812lungee
lungees84412142lungees
lunger75720422lunger
lungers83817092lungers
lungis77113022lungis
lungs65223882lun_gs
lunker104718342lunker
lunkers113414602lunkers
lunks94822452lun_ks
lunted74517522lunted
lunts55826902lun_ts
lunules738952lunules
lupines93912502lupines
lupins84514462lupins
lures56138532lu_res
lushes94022742lushes
lutes55836662lu_tes
lutzes153711922lutzes
luxes124921502lu_xes
lynxes1634322lynxes
monies83233162monies
munis75022002muni_s
nudies75217092nudies
ounces83617772ounces
plunges104011612plunges
ponies84833462ponies
punier84519222punier
puniest92918092puniest
punkies134216802punkies
punties94520782punties
rubies84420342rubies
runes55530222run_es
sanies63031952sanies
tunes55332192tun_es
tunics83811262tunics
tunnies73614262tunnies
undies73821962_undies
unites65024852_unites
units54923432_units
unties64326922_unties
zanies153219672zanies

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 Filter178691825510.343520965.0
2DLD Change Limit825511122.43633887.9
3Display Results1121120.0333393.9
 (SQL Overall)1786911122.81263545.9
 
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.