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

108 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
levis8581855(None) 
clevis1158961clevis
leis45739601le_is
lenis56326861lenis
levies93919861levies
levin84816411levin
levins94514651levins
lewis85315841lewis
lexis125916031lexis
aegis6316782aegis
alevin92511512alevin
alevins102110572alevins
bevies114017302bevies
cedis84317082cedis
defis96717502defis
delis64928542delis
devas96218882devas
devil94714732devil
devils104412812devils
devise104215752devise
devs86424032dev_s
egis56520652_egis
elemis8312382elemis
elves85118742elves
elvish1277562elvish
eves76230462_eves
evil75318072_evil
evils84114262_evils
kepis115313362kepis
kevil12399862kevil
kevils13358332kevils
lapis76223152lapis
laris54737462laris
lavas85422222lavas
laves86039152laves
lavish124112982lavish
lavs76734152lav_s
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182le_as
leaves94222382leaves
leeks95318892leeks
leers54828982leers
lees45455882le_es
leets54927122leets
lefts86517812lefts
leges64427282leges
legist71315252legist
legit61323502legit
legits71313002legits
legs56133692le_gs
lehrs86111132lehrs
lei36846382le_i_
leks85427602le_ks
lends65326252lends
lenes54738522lenes
lenos56024862lenos
lens46146492le_ns
les35663072le__s
leses54930812leses
less45635102le_ss
lets47147942le_ts
leuds66214812leuds
lev66139422lev__
leva77020712lev_a
levee84023812levee
levees93714522levees
level84116552level
levels94113282levels
lever85125162lever
levers94621322levers
levied104111432levied
levier94013872levier
leviers103510342leviers
levity1277902levity
levo76820062lev_o
levy106418502lev_y
lexes127225262lexes
leys76430182le_ys
lis37162272l__is
lives86133192lives
livid96714422livid
loris55329152loris
louis57322322louis
loves85332012loves
luvs75818502luv_s
lweis8458692lweis
lysis84511462lysis
mavis105622722mavis
metis75025902metis
neves87021872neves
nevi75116422nevi_
nevus84611392nevus
pavis106422732pavis
pelvis113610322pelvis
penis75129322penis
peris75537072peris
reis45343232re_is
revise94019742revise
revs75027052rev_s
seis45542392se_is
semis74623532semis
vis66747612__vis
yetis85418392yetis

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.0931921408.6
2DLD Change Limit538001081.79629955.5
3Display Results1081080.0333272.7
 (SQL Overall)1786911081.92292971.4
 
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.