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

147 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
lunged8541827(None) 
blunged114310131blunged
bunged105218791bunged
dunged95414691dunged
longed87121371longed
lounged9468241lounged
luged74019091lu_ged
lugged94417051lugged
lunge65323801lunge_
lungee75119811lungee
lunger75720411lunger
lunges76123421lunges
lunted74517521lunted
plunged11439511plunged
banged104923722banged
binged105920822binged
bludged12439312bludged
blunge94311482blunge_
blunger104112012blunger
blunges104212222blunges
blunted104210662blunted
bonged105719602bonged
budged114517232budged
bugged114318402bugged
bulged105117122bulged
bungee96319772bungee
bungled114112242bungled
bunked135118372bunked
bunted95219182bunted
clanged114212652clanged
clinged113310092clinged
clunked14439572clunked
danged94819482danged
dinged95221782dinged
dunked124315282dunked
dunned85015522dunned
dunted84718502dunted
fanged114318222fanged
flanged123810842flanged
flunked15398412flunked
fudged125212812fudged
fugged124615382fugged
funded114413892funded
funked144214112funked
funned103613952funned
ganged94619192ganged
glugged11396612glugged
gonged97115912gonged
gunned83513092gunned
gurged95513362gurged
hanged114222392hanged
hinged114618912hinged
hugged124113642hugged
hunger104015202hunger
hunted104417012hunted
judged165911252judged
jugged163813932jugged
jungled16349642jungled
junked184311692junked
kinged124215282kinged
kludged14366522kludged
kluged12427212klu_ged
lagged95520132lagged
lanced93717722lanced
landed84619242landed
legged95713082legged
lensed74015472lensed
lined64934642lin_ed
linger75225992linger
linked114518212linked
linted74021822linted
lodged913815702lodged
logged96622942logged
longe66626462longe_
longer75823192longer
longes75925572longes
lounge75211212lounge_
lounger84610212lounger
lounges84811352lounges
lubed85319892lu_bed
lucked135118022lucked
luffed133810822luffed
luge55531642lu_ge_
luger65322082lu_ger
luges65928752lu_ges
lugger83916552lugger
lulled74516442lulled
lumped114216962lumped
lunated8310822lunated
lunched133911822lunched
lune47140492lun_e_
lunes55337772lun_es
lunet56835422lun_et
lung55732492lung__
lungan74710212lungan
lungees84412142lungees
lungers83817082lungers
lungi65516052lung_i
lungis77113022lungis
lungs65223882lung_s
lungyi10525092lungyi
lunier64617602lunier
lunies64723012lunies
lunker104718342lunker
lured65427492lu_red
lurked114511972lurked
lushed104218722lushed
lusted74319442lusted
luted64826142lu_ted
mugged114113832mugged
nudged95511832nudged
panged104722332panged
pinged104321382pinged
plugged12408032plugged
plunge93811052plunge_
plunger104211232plunger
plunges104011612plunges
plunked14429592plunked
ponged105619352ponged
pugged114314522pugged
pungled114210082pungled
punned93416192punned
punted94618712punted
purged104918262purged
ranged84824312ranged
ringed84623842ringed
rugged94215372rugged
singed85422292singed
slanged94112852slanged
sludged103610332sludged
slugged104410372slugged
sunned74216322sunned
surged84118882surged
tanged84622492tanged
tinged84220792tinged
tonged86518902tonged
tugged93813522tugged
tuned64622312tun_ed
tunned74014492tunned
unaged83916422_unaged
unfed94614222_unfed
unled64021072_unled
unwed94114872_unwed
urged75316032_urged
venged114011982venged
winged114620832winged
zinged174414622zinged

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.1261418182.5
2DLD Change Limit825511472.64031269.3
3Display Results1471470.0463195.7
 (SQL Overall)1786911472.81263545.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.