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

103 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
levies9391986(None) 
bevies114017301bevies
levees93714521levees
levied104111431levied
levier94013871levier
leviers103510341leviers
levins94514651levins
levis85818551levi_s
aeries64737782aeries
alevins102110572alevins
belies84631052belies
cavies114525002cavies
chevies153511442chevies
civies114116442civies
clevis1158962clevi_s
clevises1336902clevises
davies105020512davies
defies104624052defies
demies94825802demies
denies74729642denies
devices133212582devices
devils104412812devils
devise104215752devise
devises114116762devises
dexies145018342dexies
elegies81312902elegies
elves85118742elv_es
envies9314052envies
eves76230462_ev_es
evils84114262_evils
evites94916472_evites
genies75324942genies
heavies132713872heavies
ivies84215762_ivies
kevils13358332kevils
ladies75124882ladies
laves86039152lav_es
lazies154418782lazies
leases65428112leases
leaves94222382leaves
leavier10319992leavier
leaviest112910822leaviest
leches115421312leches
ledges84918012ledges
lees45455882le__es
lefties10312072lefties
leges64427292le_ges
legits71313002legits
leis45739602le_i_s
lenes54738522le_nes
lenis56326862leni_s
lenites7818442lenites
lenses64620892lenses
leones64417722leones
leses54930812le_ses
lethes94818082lethes
leudes75314092leudes
levee84023812lev_ee
leveed104111372leveed
level84116552lev_el
levels94113282levels
lever85125162lev_er
levers94621322levers
levin84816412levi_n
levities11310712levities
levity1277902levity
lewis85315842lewi_s
lewises1039132lewises
lexes127225262le_xes
lexis125916032lexi_s
lezzes14387832lezzes
lezzies1536202lezzies
lies46454192l__ies
lilies63021412lilies
lives86133192liv_es
livier97514592livier
liviers104211072liviers
livres94311862livres
looies65025832looies
lories64933042lories
louies64525102louies
loves85332012lov_es
lunies64723012lunies
mavies114923192mavies
movies115118452movies
navies95218622navies
neves87021872nev_es
newies91014072newies
peavies122213402peavies
reives95723042reives
relies65036422relies
reties65436192reties
review1238692review
reviews1335532reviews
reviles104421352reviles
revise94019742revise
revises104220532revises
revives134715542revives
revues9813902revues
series64540972series
vegies104314272vegies
vies75238622__vies
wavies125019842wavies

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 Limit825511032.48333246.5
3Display Results1031030.0333121.2
 (SQL Overall)1786911032.87662131.8
 
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.