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

132 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
punier8451922(None) 
lunier64617601lunier
panier84425501panier
pinier84024691pinier
punker123718821punker
punkier133512791punkier
punner84918151punner
punnier93511261punnier
punter84320021punter
bonier84321992bonier
bunker124519372bunker
bunter85020382bunter
burier84324652burier
busier85219722busier
cunner83915002cunner
denier74420692denier
dungier9368582dungier
dunker113616462dunker
dunner73913822dunner
fumier11310902fumier
funder104016082funder
funker133915762funker
funkier14349982funkier
funner93414102funner
funnier103210172funnier
gunkier12369552gunkier
gunner73813982gunner
hunger104015202hunger
hunker133917672hunker
hunkier144512142hunkier
hunter94817772hunter
junior1386142junior
juniper1634022juniper
junker174213652junker
junkier18339492junkier
linier64423792linier
lunger75720422lunger
lunies64723012lunies
lunker104718342lunker
pacier105018682pacier
palier85023562palier
pander93725522pander
paniers94717332paniers
panner84224762panner
pannier93613352pannier
panzer174213232panzer
penner84616662penner
phonier122710632phonier
pier66035292p__ier
pincer104019172pincer
pinder94523452pinder
pinger94324092pinger
pinker125322442pinker
pinner84521502pinner
pipier104913982pipier
pitier84019822pitier
plier75221282p_lier
plumier113510042plumier
plunder103810502plunder
plunger104211242plunger
plunker133910652plunker
plunkier14305322plunkier
pokier124914632pokier
ponder94521692ponder
ponied94920702ponied
ponies84833462ponies
pornier93413132pornier
pouncer113511232pouncer
pounder103314002pounder
poutier93215322poutier
poxier153812112poxier
prier75027762p_rier
pruner83413452prun_er
pucker143817632pucker
pudgier11377722pudgier
puffer144610732puffer
puffier1547972puffier
puggier11309382puggier
puler74826622pu_ler
puller83820812puller
pulper103513272pulper
pulpier1148622pulpier
pulser84215192pulser
pumicer1335062pumicer
pumper124415552pumper
puncher143311672puncher
punchier1536412punchier
puniest92918092puniest
punily11311772punily
punish111411502punish
punisher1335772punisher
punkers133714852punkers
punkey154011172punkey
punkie123513612punkie_
punkies134216802punkies
punned93416192punned
punners94114232punners
punnet83518842punnet
punster92911102punster
punted94618712punted
punters93617042punters
punties94520782punties
purer75127902pu_rer
purger94717232purger
purser85020472purser
pursier94012752pursier
purtier93214092purtier
pusher114318282pusher
pushier123611092pushier
pussier93711992pussier
putter83921442putter
puttier93314502puttier
rubier84814742rubier
ruiner64013642ruiner
rulier65016352rulier
runner63814462runner
runnier74010112runnier
runtier73512852runtier
spinier93715162spinier
spumier1137902spumier
spunkier14235822spunkier
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.360496363.9
2DLD Change Limit825511322.50033020.4
3Display Results1321320.0632095.2
 (SQL Overall)1786911322.92361132.7
 
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.