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

164 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
lucifer123460(None) 
lucifers1334161lucifers
crucifer1543682crucifer
lacier84020092laci_er
lifer85822152l__ifer
luciferin14152462luciferin
lucite8313342lucite_
lucites9311862lucites
luckier133811532luckier
lunier64617602luni_er
aquifer1934883aquifer
blucher143310223bluc_her
bluffer15396883blu_ffer
bucker145420463buc_ker
buckler154112033buckler
buffer144512683bu_ffer
buffier1568403buffier
burier84324653buri_er
busier85219723busi_er
cider84723313__cider
citer74827333__citer
conifer123212643conifer
crucifers1643333crucifers
crucifier1644313crucifier
decider114213183decider
dicier94416233dici_er
ducker134317993duc_ker
duckier143911793duckier
duffer134711663du_ffer
duiker114110593du_iker
dulcimer1343173dulcimer
excimer1834963excimer
exciter1637753exciter
fifer115519973__fifer
fluffer12336503flu_ffer
fluffier13264333fluffier
flukier14397853fluki_er
flutier103011553fluti_er
fucker153414423fuc_ker
fumier11310903fumi_er
glacier103911303glaci_er
gluier7310263glu_i_er
guider84313523gu_ider
gulfier1137793gulfier
heifer1238203_heifer
huffier1637493huffier
icier74313753_ici_er
inciter93113773inciter
juicer1536283ju_icer
juicier1635463juicier
juniper1634023juniper
knifer13598563_knifer
lacer75833753lac__er
lacker125325623lac_ker
lacquer18135153lacquer
lakier104716273laki_er
laticifer1443733laticifer
lazier154214613lazi_er
leafier10329833leafier
lecher113415853lec_her
leucine938073leucine_
leucines1037273leucines
leucite937753leucite_
leucites1037333leucites
levier94013873levi_er
liber74723623l__iber
licker125222043lic_ker
liefer9529573l_iefer
lier45942463l__i_er
life75433733l__ife_
lifers95617843l__ifers
lifter93814813l__ifter
liger65024473l__iger
liker95627063l__iker
limier83518723limi_er
limiter92710853limiter
liner55938923l__iner
linier64423793lini_er
liter54736343l__iter
liver85132963l__iver
livier97514593livi_er
loafer93610943l_oafer
locater93113603locater
locker124019423loc_ker
logier75015733logi_er
loiter64619173l_oiter
lorimer937753lorimer
loriner7511893loriner
lousier72411623lousi_er
lowlifer1443283lowlifer
lubber104214623lu_bber
luce65132573luc__e_
lucern846103luc__ern
luces75528433luc__es
lucid84314573luci__d
lucidly13125213lucidly
luciferase1551413luciferase
luciferins15152543luciferins
luciferous1553163luciferous
lucked135118023luc_ked
luckie123611413luckie_
luckies133313683luckies
lucre76415523luc_re_
lucres84513303luc_res
luffed133810823lu_ffed
luger65322083lu__ger
lugger83916553lu_gger
luller63415483lu_ller
lumber103817773lu_mber
lumper103816653lu_mper
lumpier113410143lumpier
luncher123111413luncher
lunger75720423lu_nger
lunies64723013luni_es
lunker104718343lu_nker
lupine84013533lupine_
lupines93912503lupines
lurcher12338133lurcher
lurer54625313lu__rer
lurker103613293lu_rker
lusher93818763lu_sher
luster64023673lu_ster
lustier73813503lustier
luthier1038233luthier
mucker143816393muc_ker
muckier153411483muckier
pacier105018683paci_er
pacifier1557503pacifier
plucker15368243pluc_ker
pluckier16295073pluckier
plumier113510043plumi_er
pucker143817633puc_ker
puffer144610733pu_ffer
puffier1547973puffier
pumicer1335063pumicer
punier84519223puni_er
purifier1338573purifier
quaffer2235133quaffer
quicker2247023quicker
quiver18278743qu_iver
racier85120973raci_er
reciter94117263reciter
rifer84721983__rifer
rotifer1036993rotifer
rubier84814743rubi_er
ruiner64013643ru_iner
rulier65016353ruli_er
saucier9810283sauci_er
scuffer15328883scuffer
sucker124120663suc_ker
suckier133613973suckier
suckler133413093suckler
suffer124314513su_ffer
suiter64121813su_iter
surfer93515883su_rfer
surfier102613543surfier
thurifer1443273thurifer
tubifex1942063tubifex
tucker124316953tuc_ker
turfier10249793turfier
ulcer7310753ulc__er
unifier102211863_unifier
uniter64619143_uniter
yuckier16358533yuckier

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271646.31321230.3
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.78226347.8
 
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.