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

251 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
farers9592405(None) 
carers85133951carers
darers75921871darers
facers115519441facers
faders105117461faders
fakers134219531fakers
farcers124713441farcers
farer86733141farer_
fares85852871fare_s
farmers124315261farmers
fearers104815271fearers
firers94922681firers
parers85530741parers
afters94717072afters
agers65027852_agers
airers64922312airers
apers76629132_apers
areas55935772_areas
ares45871022_are_s
armers85520272_armers
avers85127312_avers
bakers125323452bakers
balers85626932balers
barbers114317502barbers
barer74535802barer_
bares75457132bare_s
barkers134318512barkers
barres84427542barres
barters94223032barters
bearers94619592bearers
borers85122682borers
cabers105023902cabers
cagers95624182cagers
caners84629192caners
capers105428132capers
carders104820352carders
careers95218782careers
carer74942332carer_
cares77369182care_s
caress85720262caress
carets85330772carets
carpers114521252carpers
carrs75730852car_rs
carters95327242carters
carvers124817532carvers
caters85336492caters
cavers115026832cavers
corers85231072corers
curers84923182curers
darer65230792darer_
dares66146702dare_s
darners83815772darners
darters84017602darters
daters74827362daters
eagers74523682eagers
earners74016452earners
eaters65535942eaters
fablers124812612fablers
facer105525052facer_
faces106439432face_s
facets116316652facets
fader94421512fader_
fades94932862fade_s
faery116015482fa_ery
fairer95212062fairer_
fairs85825442fa_irs
fakeers14446672fakeers
faker124824592faker_
fakery16509262fakery
fakes126032482fake_s
fakirs13468082fakirs
fallers103917992fallers
falters103916472falters
fames105735922fame_s
fanes84639892fane_s
fanners103914652fanners
faqirs18456032faqirs
farads104713272farads
farcer115016082farcer_
farces115223322farces
farceurs13464722farceurs
fardels11389892fardels
fards96629842far_ds
fare76354462fare__
fared95842342fare_d
farfels13348212farfels
farles96025782farles
farls85731112far_ls
farmer115017372farmer_
farms106324952far_ms
farness102912202farness
faros85532022far_os
farriers113610742farriers
farts88336842far_ts
fates85139232fate_s
fathers133916502fathers
faves115331422fave_s
favorers1465492favorers
favors124211402favors
fawners13388492fawners
faxes155726652faxe_s
fazes175527212faze_s
fearer94820182fearer_
feres86038182fere_s
fevers125414892fevers
fibers114717522fibers
fifers125414922fifers
filers94623722filers
firer811229252firer_
fires85740752fire_s
firmers124711442firmers
fivers124420922fivers
fixers165112982fixers
flakers143613272flakers
flamers124616362flamers
flares94521702flare_s
flayers133912032flayers
fleers96015792fleers
fliers94417192fliers
flyers125712802flyers
foamers123812102foamers
forcers124215712forcers
fores85847102fore_s
forgers115218182forgers
forkers144615782forkers
formers128217952formers
foyers125413132foyers
framers125113822framers
fraters103517202fraters
freers94717302freers
frees86131392f_rees
frere85617722f_rere
freres94716172f_reres
frets85523402f_rets
friers94718932friers
fryers125710972fryers
fuhrers1334812fuhrers
fumers113613382fumers
furlers104214222furlers
furors9310952furors
gagers84021322gagers
gamers94420822gamers
gapers94520462gapers
garners83815982garners
garters84218222garters
gaters74728632gaters
gazers164516292gazers
halers94926912halers
harems115513822harems
hares86255542hare_s
harmers124116592harmers
harpers124916202harpers
haters94930392haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
hearers104319782hearers
hirers94518062hirers
jagers144415722jagers
japers154616172japers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
larders83516942larders
larees65323112larees
lares54852632lare_s
larkers113014512larkers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
lurers64217492lurers
macers105321272macers
makers123921732makers
mares76457632mare_s
markers133516102markers
marrers93414312marrers
masers84623452masers
maters85032382maters
mazers173917092mazers
namers84517332namers
nares55544152nare_s
oaters65029782oaters
pacers105124542pacers
pagers94423252pagers
papers105125322papers
pareos87023772pareos
parer75839902parer_
pares77164482pare_s
pareus85420742pareus
parkers133816872parkers
parrs75928672par_rs
parsers94118152parsers
paters84935822paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rarer54731702rarer_
rares55247442rare_s
rasers64526782rasers
raters63936572raters
ravers94628182ravers
razers154919612razers
rearers74323562rearers
roarers73812732roarers
sabers85224732sabers
sakers104125432sakers
sarees65329942sarees
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scarers94618502scarers
sharers104720622sharers
snarers74216662snarers
soarers74118092soarers
sparers94519612sparers
starers74522312starers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
tares57456562tare_s
tarres64723042tarres
taters64932192taters
tawers94118602tawers
taxers134015282taxers
tearers75218232tearers
variers103712662variers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
warders113416812warders
wares88250582ware_s
warmers124514292warmers
warners103315562warners
warpers123413582warpers
waters95030622waters
wavers125022472wavers
waxers164014302waxers
wearers104615902wearers
wirers94617892wirers
yagers105114532yagers
yarders113211592yarders
yarer84321572yarer_
yarners104312202yarners

Search took 3 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.1231452772.4
2DLD Change Limit825512512.65631080.9
3Display Results2512510.0763302.6
 (SQL Overall)1786912512.85562588.8
 
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.