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

124 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
lunier6461760(None) 
linier64423791linier
lunger75720421lunger
lunies64723011lunies
lunker104718341lunker
punier84519221punier
blunder103813152blunder
blunger104112012blunger
blunter94512032blunter
bonier84321992bonier
bunker124519372bunker
bunter85020382bunter
burier84324652burier
busier85219722busier
clunker13419452clunker
clunkier14345792clunkier
cunner83915002cunner
denier74420692denier
dungier9368582dungier
dunker113616462dunker
dunner73913822dunner
flukier14397852flukier
flunker14389362flunker
flutier103011552flutier
fumier11310902fumier
funder104016082funder
funker133915762funker
funkier14349982funkier
funner93414102funner
funnier103210172funnier
gluier7310262glu_ier
gunkier12369552gunkier
gunner73813982gunner
hunger104015202hunger
hunker133917672hunker
hunkier144512142hunkier
hunter94817772hunter
junior1386142junior
juniper1634022juniper
junker174213652junker
junkier18339492junkier
lacier84020092lacier
lakier104716272lakier
lancer84319972lancer
lander74028482lander
lanker104123002lanker
lankier113711632lankier
lanner64920602lanner
launder8309142launder
lazier154214612lazier
lender73921272lender
levier94013872levier
lier45942462l__ier
limier83518722limier
liner55938922lin_er
linger75226002linger
lingier84113382lingier
linker104321472linker
linter64625342linter
lintier73613802lintier
livier97514592livier
logier75015732logier
loner55431042lon_er
longer75823202longer
loonier73312682loonier
lounger84610212lounger
lousier72411622lousier
lubber104214622lubber
lucifer1234602lucifer
luckier133811532luckier
luger65322082lu_ger
lugger83916552lugger
luller63415482luller
lumber103817772lumber
lumper103816652lumper
lumpier113410142lumpier
lunar57017312lun_ar
luncher123111412luncher
lune47140492lun_e_
lunes55337772lun_es
lunet56835422lun_et
lunge65323802lunge_
lunged85418272lunged
lungee75119812lungee
lungers83817092lungers
lunges76123422lunges
luniest73516992luniest
lunkers113414602lunkers
lunted74517522lunted
lurer54625312lu_rer
lurker103613292lurker
lusher93818762lusher
luster64023672luster
lustier73813502lustier
luthier1038232luthier
panier84425502panier
pinier84024692pinier
plumier113510042plumier
plunder103810502plunder
plunger104211242plunger
plunker133910652plunker
plunkier14305322plunkier
punker123718822punker
punkier133512792punkier
punner84918152punner
punnier93511262punnier
punter84320022punter
rubier84814742rubier
ruiner64013642ruiner
rulier65016352rulier
runner63814462runner
runnier74010112runnier
runtier73512852runtier
sunder74019822sunder
sunnier73412152sunnier
tinier63622232tinier
tonier65520712tonier
tuner56022682tun_er
under64624212_under
uniter64619142_uniter
vinier93716742vinier
wanier93920682wanier
winier94522452winier
zanier154314712zanier

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.346516448.0
2DLD Change Limit825511242.21637252.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911242.60868516.5
 
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.