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

126 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
clavers12431489(None) 
cavers115026831c_avers
claver113816971claver_
claves115020061clave_s
claviers1367101claviers
clawers123910961clawers
cleavers13398861cleavers
clivers123411751clivers
clovers125114661clovers
cravers124416541cravers
lavers94526361_lavers
slavers103716501slavers
avers85127312__avers
beavers124417322beavers
bladers104214682bladers
blamers115314212blamers
blazers184811682blazers
bravers124715522bravers
cabers105023902c_abers
cadavers1435862cadavers
cagers95624182c_agers
calkers134414692calkers
callers94221962callers
calves115119282calve_s
caners84629192c_aners
capers105428132c_apers
carers85133952c_arers
carvers124817532carvers
caters85336492c_aters
caver105629062c_aver_
cavern115312452c_avern
caverns124510242c_averns
caves105639702c_ave_s
chafers154512722chafers
chasers123714892chasers
chawers154412032chawers
clabbers14359892clabbers
clackers163911702clackers
clades94920462clade_s
claimers12298742claimers
clambers144211282clambers
clammers143510682clammers
clamors11710092clamors
clampers143211882clampers
clangers114312342clangers
clappers143310832clappers
claquers19226192claquers
clarets94111102clarets
clashers134213992clashers
claspers124410912claspers
classers104111832classers
clatters103313902clatters
clave105420152clave__
clavered14187632clavered
clavier1239172clavier_
clavus11347352clav_us
clawer114512782clawer_
cleaners103610532cleaners
clearers10349292clearers
cleaver124110802cleaver_
cleaves124111622cleave_s
clever114611532clever_
cloners94514822cloners
closers94415312closers
clover114617122clover_
clovery15407402clovery
cloves114918822clove_s
coalers94419332coalers
coaters93525772coaters
coaxers164311062coaxers
covers114627962c_overs
craters95021882craters
cravens124010112cravens
craver114618462craver_
craves115825392crave_s
culvers12329822culvers
elaters74420182elaters
elvers93814982el_vers
flakers143613272flakers
flamers124616362flamers
flavors1337292flavors
flayers133912032flayers
glazers174410032glazers
glovers114310882glovers
gravers114515262gravers
halvers133311422halvers
havers124721482_havers
heavers133717192heavers
klavern1433002klavern
klaverns1532242klaverns
lacers85225252_lacers
laders74927762_laders
lagers74826142_lagers
lakers105225152_lakers
lasers64925702_lasers
laveers10329362_laveers
laver85031792_laver_
laves86039152_lave_s
layers93921182_layers
leavers103717782leavers
levers94621322_levers
livers94927822_livers
lovers94223432_lovers
palavers1337992palavers
pavers115021822_pavers
placers114515262placers
planers94517942planers
platers93924082platers
players124313762players
plovers123611832plovers
quavers19309002quavers
ravers94628182_ravers
reavers108320742reavers
salvers103916002salvers
savers93825922_savers
shavers134115092shavers
slakers114115752slakers
slaters73123722slaters
slaver94419612slaver_
slavery13407892slavery
slaves95023022slave_s
slaveys13415202slaveys
slayers104513322slayers
slivers104115252slivers
wavers125022472_wavers
weavers133714462weavers

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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711263.28032826.5
3Display Results1261260.0462739.1
 (SQL Overall)1786911263.46651555.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.