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

292 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
lavers9452636(None) 
avers85127311_avers
cavers115026831cavers
clavers124314891clavers
havers124721481havers
lacers85225251lacers
laders74927761laders
lagers74826141lagers
lakers105225151lakers
lasers64925701lasers
laveers10329361laveers
laver85031791laver_
laves86039151lave_s
layers93921181layers
leavers103717781leavers
levers94621321levers
livers94927821livers
lovers94223431lovers
pavers115021821pavers
ravers94628181ravers
savers93825921savers
slavers103716501slavers
wavers125022471wavers
agers65027852_agers
aivers94822322aivers
alders74218422alders
alters64924222alters
apers76629132_apers
avens86419332_avens
aver75931882_aver_
averse95811182_averse
avert86029492_avert
averts95715242_averts
aves76142602_ave_s
bakers125323452bakers
balers85626932balers
beavers124417322beavers
bladers104214682bladers
blamers115314212blamers
blazers184811682blazers
bravers124715522bravers
cabers105023902cabers
cagers95624182cagers
caners84629192caners
capers105428132capers
carers85133952carers
carvers124817532carvers
caters85336492caters
caver105629062caver_
cavern115312452cavern
caverns124510242caverns
caves105639702cave_s
claver113816972claver_
claves115020062clave_s
claviers1367102claviers
clawers123910962clawers
cleavers13398862cleavers
clivers123411752clivers
clovers125114662clovers
covers114627962covers
cravers124416542cravers
darers75921872darers
daters74827362daters
davens104612912davens
divers105024962divers
eagers74523682eagers
eaters65535942eaters
eaves85231992eave_s
elaters74420182elaters
elvers93814982elvers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
faves115331422fave_s
favors124211402favors
fevers125414892fevers
fivers124420922fivers
flakers143613272flakers
flamers124616362flamers
flavors1337292flavors
flayers133912032flayers
gagers84021322gagers
gamers94420822gamers
gapers94520462gapers
gaters74728632gaters
gavels105911092gavels
gazers164516292gazers
givers104817712givers
glazers174410032glazers
glovers114310882glovers
gravers114515262gravers
halers94926912halers
halvers133311422halvers
haters94930392haters
havens124514042havens
haver115124462haver_
haves116034872have_s
hayers124415942hayers
hazers184615952hazers
heavers133717192heavers
hovers124320252hovers
jagers144415722jagers
japers154616172japers
jivers164515642jivers
klavern1433002klavern
klaverns1532242klaverns
laagers83411252laagers
labels84515682labels
labors84016402labors
lacer75833752lacer_
laces76141762lace_s
lackers134120542lackers
ladders94115172ladders
ladens74516232ladens
lader65633722lader_
lades65141272lade_s
ladlers84613562ladlers
lager65132862lager_
laggers94216242laggers
lahars94013162lahars
lairs55425872la_irs
laker95432872laker_
lakes95737652lake_s
lambers113817102lambers
lameds94812032lameds
lamer75233702lamer_
lames75445542lame_s
lampers113817332lampers
lancers93616642lancers
landers84026212landers
lanes54946792lane_s
lanners73618322lanners
lapels83712042lapels
lappers113717462lappers
lapsers93911052lapsers
larders83516942larders
larees65323112larees
lares54852632lare_s
larkers113014512larkers
lars46956572la__rs
laser54633322laser_
lases54944762lase_s
lashers104121832lashers
lasters75627692lasters
latens64620212latens
later54843922later_
lathers104321882lathers
lauders84012892lauders
lavas85422222lav_as
lave75642142lave__
laved95028592lave_d
laveer94110422laveer
lavs76734152lav__s
lawyers13377152lawyers
laxer125420332laxer_
laxes125430092laxe_s
layer84626472layer_
layovers1434072layovers
lazars153812392lazars
lazes145129572laze_s
leaders83819602leaders
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leasers74717842leasers
leavens10409302leavens
leaver94321512leaver_
leaves94222382leave_s
leers54828982l_eers
legers74518312legers
lepers84817322lepers
levees93714522levees
levels94113282levels
lever85125162lever_
leviers103510342leviers
libers84721432libers
liers55130402l_iers
lifers95617842lifers
ligers75022022ligers
likers104620912likers
liners65428842liners
liters65429872liters
livens94314892livens
liver85132962liver_
livery124910892livery
lives86133192live_s
liviers104211072liviers
livres94311862livres
livyers13365902livyers
loaders83413412loaders
loafers10349462loafers
loaners73913622loaners
loaves94813852loave_s
loners64225802loners
lopers84424142lopers
losers65123582losers
louvers10359102louvers
lover85526452lover_
loves85332012love_s
lowers94624922lowers
lugers74617022lugers
lurers64217492lurers
macers105321272macers
makers123921732makers
masers84623452masers
maters85032382maters
mavens114312972mavens
mazers173917092mazers
movers115117192movers
namers84517332namers
navars92810572navars
navels95712692navels
naves87030382nave_s
oaters65029782oaters
oaves84925612oave_s
overs85224792_overs
pacers105124542pacers
pagers94423252pagers
palavers1337992palavers
papers105125322papers
parers85530742parers
paters84935822paters
paver104225832paver_
paves104833922pave_s
pawers114818782pawers
payers114621822payers
placers114515262placers
planers94517942planers
platers93924082platers
players124313762players
plovers123611832plovers
quavers19309002quavers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rasers64526782rasers
raters63936572raters
ravels94717072ravels
ravens93916882ravens
raver85631492raver_
raves85441972rave_s
razers154919612razers
reavers108320742reavers
revers94529632revers
rivers94626542rivers
rovers95423522rovers
sabers85224732sabers
sakers104125432sakers
salvers103916002salvers
saver84831252saver_
saves85838632save_s
savors95616102savors
sawers94620162sawers
sayers94221592sayers
severs94121122severs
shavers134115092shavers
sivers95324152sivers
slakers114115752slakers
slaters73123722slaters
slaver94419612slaver_
slavery13407892slavery
slaves95023022slave_s
slaveys13415202slaveys
slayers104513322slayers
slivers104115252slivers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932192taters
tavern9428932tavern
taverns10317802taverns
tawers94118602tawers
taxers134015282taxers
vivers124717362vivers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
waivers133410052waivers
wakers134822492wakers
walers94824462walers
waters95030622waters
waver115025702waver_
wavery154610052wavery
waves115633922wave_s
waveys15597012waveys
waxers164014302waxers
weavers133714462weavers
wivers125320802wivers
yagers105114532yagers

Search took 4 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.1261418182.5
2DLD Change Limit825512923.12326433.2
3Display Results2922920.1102654.5
 (SQL Overall)1786912923.35953197.7
 
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.