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

123 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
careers9521878(None) 
carders104820351carders
careens94514701careens
career85822241career_
carers85133961car_ers
carpers114521251carpers
carters95327251carters
carvers124817531carvers
ameers84015572_ameers
armers85520272_armers
barbers114317502barbers
barkers134318512barkers
barters94223032barters
cabers105023922ca_bers
cablers114416712cablers
cadgers114712002cadgers
cagers95624192ca_gers
cahiers123510672cahiers
calkers134414692calkers
callers94221962callers
cambers134017442cambers
campers134220292campers
cancers114018582cancers
caners84629202ca_ners
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
caperers122611722caperers
capers105428142ca_pers
cappers134419402cappers
carcels114516062carcels
carder94524182carder_
careen84119492caree_n
careeners1138532careeners
careered1139492careered
careerer1038582careerer
careerers1137242careerers
careerism1345622careerism
careerist1148792careerist
careless102813632careless
carer74942332car_er_
cares77369182car_e_s
caress85720262car_ess
caressers1137432caressers
carets85330772car_ets
caries85147622carie_s
carles85435082carle_s
carless95118492carless
carnets93918402carnets
carneys124310542carneys
carolers103314172carolers
carpels115315462carpels
carper104923632carper_
carpets113915332carpets
carrels95117302carrels
carriers103614202carriers
carrs75730852car__rs
carses85233652carse_s
cartels94618122cartels
carter84932272carter_
cartes86239472carte_s
carvels124914592carvels
carver114420142carver_
carves115128452carve_s
casters94729902casters
caterers102814402caterers
caters85336502ca_ters
causers94014792causers
cavers115026842ca_vers
chargers144011322chargers
charmers154211332charmers
charters134115582charters
cheers114518912c_heers
corders104520882corders
corers85231072cor_ers
corkers134118852corkers
corners94723312corners
craters95021892craters
cravers124416552cravers
creeds94714772c_reeds
creeks124812922c_reeks
creels84416942c_reels
creeps104213622c_reeps
criers83918582c_riers
curbers115514382curbers
curers84923192cur_ers
curlers94218072curlers
cursers94317162cursers
darers75921872dar_ers
darners83815772darners
darters84017602darters
earners74016452earners
fakeers14446672fakeers
farcers124713442farcers
farers95924052far_ers
farmers124315262farmers
freers94717302_freers
garners83815982garners
garters84218232garters
hareems12428202hareems
harmers124116592harmers
harpers124916202harpers
larders83516942larders
larees65323112laree_s
larkers113014512larkers
laveers10329362laveers
markers133516102markers
marrers93414312marrers
parers85530742par_ers
parkers133816872parkers
parsers94118152parsers
sarees65329942saree_s
scarers94618512scar_ers
scarfers13408462scarfers
scarpers124712512scarpers
variers103712662variers
warders113416812warders
warmers124514292warmers
warners103315562warners
warpers123413582warpers
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.376475242.0
2DLD Change Limit1076711233.09334811.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.51550836.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.