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

120 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
lucifers133416(None) 
lucifer1234601lucifer_
crucifers1643332crucifers
lifers95617842l__ifers
luciferase1551412luciferase
luciferin14152462luciferin
luciferins15152542luciferins
luciferous1553162luciferous
lucites9311862lucite_s
aquifers2044393aquifers
bluchers15359033bluc_hers
bluffers16405703blu_ffers
buckers153517453buc_kers
bucklers16349503bucklers
buffers153310793bu_ffers
buriers94017193buri_ers
ciders94620093__ciders
citers85022983__citers
conifers133611703conifers
crucifer1543683crucifer_
crucifiers1743073crucifiers
deciders123510753deciders
duckers143214713duc_kers
duffers143410093du_ffers
duikers12369383du_ikers
dulcimers1442413dulcimers
excimers1944703excimers
exciters1736323exciters
fifers125414923__fifers
fluffers13335293flu_ffers
fuckers163611593fuc_kers
glaciers11277893glaci_ers
guiders94111113gu_iders
heifers1337933_heifers
inciters103210673inciters
juicers1636153ju_icers
junipers1733933junipers
knifers14537083_knifers
lacers85225253lac__ers
lacier84020093laci_er_
laciness102112553laciness
lackers134120543lac_kers
lacquers19125033lacquers
lanciers10308543lanci_ers
laticifers1542463laticifers
lechers123313963lec_hers
leucines1037273leucine_s
leucites1037333leucite_s
leviers103510343levi_ers
libers84721443l__ibers
lickers134118253lic_kers
liers55130403l__i_ers
lifer85822153l__ifer_
lifters104313783l__ifters
ligers75022043l__igers
likers104620913l__ikers
limiters10249333limiters
liners65428853l__iners
liters65429883l__iters
livers94927823l__ivers
liviers104211073livi_ers
loafers10349463l_oafers
locaters102710073locaters
lockers133516923loc_kers
loiters74116613l_oiters
lorimers1036613lorimers
loriners839963loriners
lowlifers1542953lowlifers
lubbers113913723lu_bbers
lucern846103luc__ern
lucerns935753luc__erns
luces75528433luc__e_s
lucidness1244313lucidness
luciferases1651333luciferases
lucite8313343lucite__
luckier133811533luckier_
luckies133313683luckie_s
luckiness1596573luckiness
luckless14265893luckless
lucres84513303luc_re_s
lugers74617023lu__gers
luggers93713483lu_ggers
lullers73213353lu_llers
lumbers113815913lu_mbers
lumpers113514483lu_mpers
lunchers13349563lunchers
lungers83817093lu_ngers
lunier64617603luni_er_
lunies64723013luni_e_s
lunkers113414603lu_nkers
lupines93912503lupine_s
lurchers13307153lurchers
lurers64217493lu__rers
lurkers113910083lu_rkers
lusters73921443lu_sters
luthiers1135163luthiers
muckers153612803muc_kers
pacifiers1645463pacifiers
pluckers16316553pluc_kers
puckers153514673puc_kers
puffers15349203pu_ffers
pumicers1434353pumicers
purifiers1435873purifiers
quaffers2333963quaffers
quivers19298753qu_ivers
reciters102613113reciters
rotifers1136043rotifers
ruiners74213023ru_iners
sauciers1076733sauci_ers
scuffers16307493scuffers
suckers133717623suc_kers
sucklers14379963sucklers
suffers133113543su_ffers
suiters73618883su_iters
surfers103614133su_rfers
thurifers1542913thurifers
tuckers134014353tuc_kers
ulcers839383ulc__ers
unifiers11237173_unifiers
uniters73814173_uniters

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621206.18623627.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.67226782.2
 
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.