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

144 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
carvers12481753(None) 
carders104820351carders
careers95218781careers
carers85133961car_ers
carpers114521251carpers
carters95327251carters
carvels124914591carvels
carver114420141carver_
carves115128451carve_s
cavers115026841ca_vers
cravers124416551cravers
aivers94822322_aivers
armers85520272_armers
avers85127312_a_vers
barbers114317502barbers
barkers134318512barkers
barters94223032barters
bravers124715522bravers
cabers105023922ca_bers
cablers114416712cablers
cadavers1435882cadavers
cadgers114712002cadgers
cagers95624192ca_gers
cahiers123510672cahiers
calkers134414692calkers
callers94221962callers
calves115119282calve_s
cambers134017442cambers
campers134220292campers
cancers114018582cancers
caners84629202ca_ners
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
capers105428142ca_pers
cappers134419402cappers
caravels1337432caravels
carcels114516062carcels
carder94524182carder_
careens94514702careens
career85822242career_
carer74942332car_er_
cares77369182car_e_s
caress85720262car_ess
carets85330772car_ets
caries85147622carie_s
carles85435082carle_s
carless95118492carless
carnets93918402carnets
carneys124310542carneys
carolers103314172carolers
carpels115315462carpels
carper104923632carper_
carpets113915332carpets
carrels95117302carrels
carriers103614202carriers
carrs75730852car__rs
carses85233652carse_s
cartels94618122cartels
carter84932272carter_
cartes86239472carte_s
carve106227752carve__
carved124320852carve_d
carvel114817572carve_l
carven114716662carve_n
casters94729902casters
caters85336502ca_ters
causers94014792causers
caver105629062ca_ver_
cavern115312452ca_vern
caverns124510252ca_verns
caves105639702ca_ve_s
chargers144011322chargers
charmers154211332charmers
charters134115582charters
clavers124314902clavers
clivers123411752clivers
clovers125114662clovers
corders104520882corders
corers85231072cor_ers
corkers134118852corkers
corners94723312corners
corvees124613792corvees
corves115122522corve_s
corvets124715022corvets
covers114627962c_overs
craters95021892craters
cravens124010112cravens
craver114618462craver_
craves115825392crave_s
criers83918582c_riers
culvers12329832culvers
curbers115514382curbers
curers84923192cur_ers
curlers94218072curlers
cursers94317162cursers
curves114619282curve_s
curvets12399912curvets
darers75921872dar_ers
darners83815772darners
darters84017602darters
earners74016452earners
farcers124713442farcers
farers95924052far_ers
farmers124315262farmers
garners83815982garners
garters84218232garters
garveys14124462garveys
gravers114515272gravers
halvers133311422halvers
harmers124116592harmers
harpers124916202harpers
havers124721482ha_vers
jarveys20123412jarveys
larders83516942larders
larkers113014512larkers
lavers94526362la_vers
markers133516102markers
marrers93414312marrers
marvels123810092marvels
parers85530742par_ers
parkers133816872parkers
parsers94118152parsers
pavers115021822pa_vers
ravers94628182ra_vers
salvers103916002salvers
savers93825922sa_vers
scarers94618502scar_ers
scarfers13408462scarfers
scarpers124712512scarpers
scarves124511622scarve_s
servers103214832servers
starvers11459642starvers
variers103712662variers
varves124414782varve_s
waivers133410052waivers
warders113416812warders
warmers124514292warmers
warners103315562warners
warpers123413582warpers
wavers125022472wa_vers
yarders113211592yarders
yarners104312202yarners

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.1261418182.5
2DLD Change Limit1076711443.73328843.0
3Display Results1441440.0463130.4
 (SQL Overall)1786911443.90545759.5
 
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.