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 “carfare” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

219 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
carfare1231007(None) 
carfares13310321carfares
warfare1336731warfare
airfare1047242airfare
barware12610702barware
carafe115416162car_afe
carate84734002car_ate
carbarn1139452carbarn
carcase11312742carcase
carnage10311742carnage
carpale113414352carpale
cartage10312592cartage
catface1436762catface
caviare1238372caviare
curare84916952cur_are
fanfare1336672fanfare
tartare73012682tartare
warfares1436682warfares
acreage1037843acreage
afar76720783_a_far_
afars85716513_a_fars
affaire1344463_affaire
afire86215913_a_fire
afore85818603_a_fore
aglare7312433_aglare
airfares1146693airfares
arame75026623_ar_ame
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
ariary94114203_ariary
armure8710133_armure
aware86420023_a_ware
barbate11314543barbate
barrage10710843barrage
barre75929543bar__re
barwares13610093barwares
cabaret112519043ca_baret
cabbage1446983cabbage
cadre85419023ca__dre
caesar8410933caesar_
caesars9410733caesars
cafe95230323ca_f__e
calcar10312753calcar_
calcars11312653calcars
calibre1136603calibre
califate13310483califate
calvary1537183calvary
camerae11312063camerae
campfire1744023campfire
canape10913513ca_nape
canard9314763ca_nard
canary11314693ca_nary
caneware1347803caneware
capture1138913capture
caracara1247263caracara
carack142113173car_ack
carafes125015703carafes
caramel11310253car_amel
carapace1446093carapace
carat75048793car_a_t
carates95630613car_ates
carats85929023car_ats
caravel1238213car_avel
carbarns1238563carbarns
carbaryl1544423carbaryl
carbide126112493carbide
carbine112918643carbine
carbora11310703carbora
carburet12411113carburet
carcanet12316353carcanet
carcases12313093carcases
carcass11310513carcass
cardcase1345983cardcase
carder94524183carder_
carders104820353carders
cardiae10713713cardiae
care66968373c___are
career85822243career_
careered1139493careered
careerer1038583careerer
careers95218783careers
carefree1346343carefree
carer74942333car_er_
carers85133963car_ers
caretake1446773caretake
carful11610973carf_ul
carfuls1249133carfuls
caribe103416753car_ibe
carinae94318593carinae
carinate103320253carinate
cariole9818343cariole
carjack2246153carjack
carle74535703car__le
carline93923613carline
carmaker1637313carmaker
carman103920743carma_n
carmine112918483carmine
carnages11312213carnages
carnal83919213carna_l
carnie84421093car_nie
caroach1488863caroach
caroche1469243caroche
caroler93816753caroler
carouse9614423carouse
carpal103716253carpa_l
carpals113414633carpals
carper104923633carper_
carpers114521253carpers
carport11316033carport
carr65434703car__r_
carrack1548753carrack
carrel84718633car__rel
carriage1137853carriage
carrier93619583carrier
carrs75730853car__rs
carry105823783car__ry
carse74934333car__se
cartable121314093cartable
cartages11313313cartages
carte75940423car__te
carter84932273carter_
carters95327253carters
carve106227753car__ve
carver114420153carver_
carvers124817543carvers
carwash1536003carwash
cascade12118603cascade
cascara1138313cascara
casease939323casease
caseate9314783caseate
catfaces1536963catfaces
catfall1237393catfall
caudate10311353caudate
caviar11310163caviar_
caviares1337993caviares
caviars1238623caviars
centare93113703centare
cerate84829463cer_ate
charade13129913char_ade
chare105231983c__hare
cirrate92413493cirrate
clayware1643933clayware
compare135814993compare
cordage11310063cordage
cordate10315223cordate
corkage1438373corkage
corrade101111043corrade
corsage1039803corsage
crafter124111333crafter
crake114823523c_r_ake
crane75331603c_r_ane
crape96128443c_r_ape
crate76537403c_r_ate
crave105626313c_r_ave
craze165221463c_r_aze
crease85519573c_rease
create85126383c_reate
crore74922873c_r_ore
curara83712203cur_ara
curares94916853cur_ares
curari84414403cur_ari
curate85226243cur_ate
curiae84518373curia_e
curtate9312643curtate
darbar959953darbar_
darbars10510093darbars
daycare1355093daycare
daymare1375633daymare
earmark1345653earmark
fanfares1436773fanfares
fare76354463___fare
farfal123410183farfa_l
farfalle1445063farfalle
farfals13268503farfals
forbare122310513forbare
garage8314513gar_age
garbage1138053garbage
hardware1546283hardware
infare9313083_infare
karate105320923kar_ate
larvae938843larva_e
narrate7313493narrate
parade94720643par_ade
parae76335703par_a_e
parbake1538353parbake
parfait12312053parfait
parkade1437583parkade
partake1339643partake
parure8312523par_ure
rare45348433__r_are
safari91110223sa_fari
sarape84817573sar_ape
sardar73013173sardar_
sardars83112903sardars
sarsar63011843sarsar_
sarsars73512143sarsars
scalare93311833sca_lare
scarfer124511083scarfer_
scarfers13408463scarfers
serfage1138403serfage
surface1238653surface
taffarel1442563taffarel
tarre55825633tar__re
tartar63214753tartar_
tartars73313403tartars
urare56322553_ur_are
variate101316433variate
warfarin1444983warfarin
warpage1336403warpage
wayfarer1742923wayfarer
welfare1335713welfare
wharfage1842213wharfage
workfare1843123workfare
yardage1235733yardage
yardarm13114533yardarm
zaffar21385043zaffar_
zaffars22325233zaffars
zaffre21354663za_ffre

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272197.32618294.7
3Display Results2192190.0962281.3
 (SQL Overall)1786912197.82822827.2
 
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.