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

93 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
liever9461186(None) 
lever85125161l_ever
lieder74912321lieder
liefer9529571liefer
lieve86315471lieve_
liver85132961li_ver
riever94811651riever
aiver85725162ai_ver
aliener71011192aliener
believer13448422believer
clever114611532clever
dieter73516772dieter
diver94827802di_ver
ever77027692__ever
fever115617952_fever
fiver116024942fi_ver
flivver1633042flivver
giver94921202gi_ver
griever1136032griever
jiver155119052ji_ver
laveer94110422laveer
laver85031792l_aver
leaver94321512leaver
leer46239352l_e_er
leger65721502l_eger
leper74820742l_eper
levee84023812l_evee
level84116552l_evel
levers94621322l_evers
levier94013872l_evier
libber104414002libber
libeler9219002libeler
liber74723612li_ber
licker125222042licker
liege65314432liege_
lieges74113442lieges
lier45942462li__er
lievest1048342lievest
lifer85822152li_fer
lifter93814812lifter
liger65024462li_ger
liker95627062li_ker
limber104316772limber
limier83518712limier
limmer104314792limmer
limner84112862limner
limper104117852limper
liner55938912li_ner
linger75225992linger
linier64423782linier
linker104321462linker
linter64625332linter
lipper104219632lipper
lisper84114432lisper
lister64527252lister
liter54736342li_ter
lither94520952lither
litter64324852litter
live76540992li_ve_
lived95523722li_ved
liven85021732li_ven
livener10278932livener
livers94927822li_vers
livery124910892li_very
lives86133192li_ves
livier97514592livier
livre85613252li_vre
livyer12426292livyer
louver94110392louver
lover85526452l_over
never86218642_never
nieve85613182nieve_
nieves94311292nieves
piecer105213082piecer
reiver95318292reiver
reliever11448682reliever
rievers104311452rievers
river85731692ri_ver
sever85426052_sever
sieve84918842sieve_
sieved104611442sieved
sievert10613292sievert
sieves93216002sieves
silver93815812silver
siver85728612si_ver
slieve9359272slieve_
slieves10378962slieves
sliver94116592sli_ver
soever94412092soever
viewer1237212viewer
weever123811442weever
wiener94513542wiener
wiver115924512wi_ver

Search took 5 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.220812231.8
2DLD Change Limit82551934.28019287.6
3Display Results93930.0303100.0
 (SQL Overall)178691934.53039446.1
 
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.