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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

153 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
lekvars143269(None) 
lekvar1333041lekvar_
lears55938732le__ars
leavers103717782leavers
levers94621322le_vers
alegars838933ale_gars
bears75739043be__ars
beavers124417323beavers
beggars11378223beggars
bevors111610343be_vors
bezoars1836793bezoars
blears85116453ble__ars
cedars93312833ce_dars
cellars93713693cellars
clears84116563cle__ars
cleavers13398863cleavers
dears65736883de__ars
debars94218043de_bars
dekare112811563dek_are
dekares122710873dek_ares
delvers113411993delvers
denars74621433de_nars
deodars937623deodars
devas96218883de_va_s
dewars105117073de_wars
ears46356593_e__ars
eggars8398973_eggars
elvers93814983_elvers
embars103812873_embars
escars83913133_escars
eskars10357593_eskars
fears84829393fe__ars
fervors1336233fervors
feuars938653fe_uars
fevers125414893fe_vers
gears64628693ge__ars
hears86737373he__ars
heavers133717193heavers
hektare1435503hektare
hektares1535813hektares
invars9310003_invars
kbars114612603__kbars
kebars124112493ke_bars
knars94416113__knars
kvas117015943__kva_s
kvass12507273__kvass
kyars124813963__kyars
lahars94013163l_ahars
lakers105225153lak_ers
lars46956573l___ars
larvas9310233larva_s
lascars979013lascars
lavas85422223l_ava_s
lavers94526363l_avers
lazars153812393l_azars
leaders83819603leaders
leads66028493le__ads
leafs85721183le__afs
leakers113415423leakers
leaks95923913le__aks
leaners73718173leaners
leans55536253le__ans
leapers93716663leapers
leaps75522933le__aps
lear47045953le__ar_
learn55322663le__arn
learns65513743le__arns
leary85927383le__ary
leas45954183le__a_s
leasers74717843leasers
leavens10409303leavens
leaver94321513leaver_
leaves94222383leav_es
lechers123313963lechers
lectors93415763lectors
ledgers94912173ledgers
leers54828983le__ers
leeward1135783leeward
leewards1244983leewards
leeways1354453leeways
legals73412733le_gals
legers74518313le_gers
lehrs86111133le__hrs
lehuas935943lehua_s
leks85427603lek___s
lemans85316393le_mans
lemmas10349163lemma_s
lemurs837253le_murs
lenders84419643lenders
leopard1045293leopard
leopards1144753leopards
leotard846193leotard
leotards945303leotards
lepers84817323le_pers
lessors73610523lessors
lethals1038113lethals
letters73819853letters
leva77020713le_va__
levant9314493le_vant
levants1037723le_vants
levators11249283le_vators
levees93714523le_vees
levels94113283le_vels
lever85125163le_ver_
leviers103510343leviers
levies93919863le_vies
levins94514653le_vins
levis85818553le_v_is
liars54723163l__iars
lidars7310783l_idars
likers104620913lik_ers
livers94927823l_ivers
louvers10359103louvers
lovats939073l_ovats
lovers94223433l_overs
lumbars11289763lumbars
lunars65012813l_unars
makars124612633mak_ars
medlars10259443medlars
mikvahs19162493mikvahs
navars92810573_navars
nears55529423ne__ars
nectars938463nectars
pears75138613pe__ars
pedlars103210213pedlars
pekans121710553pek_ans
rears54739653re__ars
reavers108320743reavers
rebars84019823re_bars
redears82814453redears
regears83012463regears
rehears103312773rehears
reivers105117083reivers
retears72814923retears
revers94529633re_vers
rewears102911033rewears
sears54744913se__ars
secpars1138413secpars
seggars9377783seggars
selvas93812913selva_s
serovars1145233serovars
servals103410743servals
servers103214833servers
severs94121123se_vers
sewars94018623se_wars
tears55436463te__ars
vars75742073___vars
velars93913723ve_lars
wears86030303we__ars
weavers133714463weavers
weevers13379993weevers
wekas123911793wek_a_s
years84527673ye__ars

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271537.00019146.7
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.21924752.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.