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 “ivied” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
ivied9471052(None) 
ivies84215761ivies
vied86328631_vied
avid88325962avi_d
chivied16368382chivied
citied94014142citied
civie103716352civie_
civies114116442civies
cried84624292cried
died66137852_died
dived106321372div_ed
divide113410892divide
divided13378592divided
divined12329692divined
divvied1544812divvied
dried75321382dried
envied1038832envied
evited104013142evited
flied96519432flied
fried95322912fried
gied64631982_gied
hied85434042_hied
hived125217912hiv_ed
iced78721892i_ced
icier74313752icier
idled74915212idled
igged86012762igged
iliad64613462iliad
imbed105013652imbed
imid76122292imi_d
imide85716892imide
imped105117982imped
inked104218522inked
inned64118422inned
invited113612462invited
ired55131872i_red
irid55927172iri_d
irised73913152irised
irked104510922irked
isled64615992isled
jived165115042jiv_ed
jivier16438612jivier
levied104111432levied
lied55838092_lied
lilied73913212lilied
lived95523722liv_ed
livid96714422livi_d
livier97514592livier
pied75035362_pied
pitied94017252pitied
plied85118592plied
pried84426862pried
rived94825612riv_ed
shied96125492shied
skied104417752skied
spied85427712spied
stied65723032stied
tidied83613272tidied
tied55535212_tied
tried65026912tried
viced115118182viced
vid77241812_vi_d
vide85432762_vide
vie65447632_vie_
vier75428152_vier
vies75238622_vies
view105917672_view
vined95626152vined
vised95518762vised
vivid125112312vivi_d
wived125121502wiv_ed
wried95518562wried

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800721.51335558.5
3Display Results72720.0164500.0
 (SQL Overall)178691721.84297009.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.