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

207 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
carfares1331032(None) 
carfare12310071carfare_
warfares1436681warfares
airfares1146692airfares
barwares13610092barwares
carafes125015702car_afes
carates95630612car_ates
carbarns1238562carbarns
carcases12313092carcases
carnages11312212carnages
cartages11313312cartages
catfaces1536962catfaces
caviares1337992caviares
curares94916852cur_ares
fanfares1436772fanfares
warfare1336732warfare_
acariases1146613acariases
acreages1138373acreages
afars85716513_a_far_s
affaires1444303_affaires
airfare1047243airfare_
arames84622573_ar_ames
arbores94016033_arbores
arcades101113193_arcades
armures9510273_armures
arrases71214543_arrases
barflies1338303barflies
barrages11711083barrages
barres84427543bar__res
barware12610703barware_
cabaret112519043ca_baret
cabarets12268463ca_barets
cabbages1537203cabbages
cadres94017933ca__dres
caesars9410733caesar_s
cafes106426923ca_f__es
calcars11312653calcar_s
calibres1237103calibres
califates14310113califates
calvaries1449803calvaries
camases114216343ca_mases
campfires1844123campfires
canapes111213083ca_napes
canards10311203ca_nards
canaries10318943ca_naries
canewares1447363canewares
canvases13349523canvases
capiases1239253capiases
captures1239443captures
caracaras1346863caracaras
caracks152211563car_acks
carafe115416163car_afe_
caramel11310253car_amel
caramels1238803car_amels
carapaces1546053carapaces
carapaxes2044833carapaxes
carate84734003car_ate_
carats85929023car_a_ts
caravel1238213car_avel
caravels1337443car_avels
carbarn1139453carbar_n
carbaryl1544423carbaryl
carbaryls1644013carbaryls
carbides133111693carbides
carbines123617543carbines
carboras12311583carboras
carburet12411113carburet
carburets1345203carburets
carcanet12316353carcanet
carcanets1347313carcanets
carcase11312743carcase_
carcass11310513carca_ss
carcasses1337483carcasses
cardcases1446513cardcases
carders104820353carder_s
careered1139493careered
careerer1038583careerer
careerers1137243careerers
careers95218783career_s
carefree1346343carefree
carers85133963car_er_s
cares77369183c___ares
caresses10314063caresses
caretakes1547143caretakes
carfuls1249133carf_uls
cargoes104415223car_goes
caribes113715643car_ibes
carices114220953car_ices
caries85147623car__ies
carioles10817073carioles
caritases1139763caritases
carjacks2345573carjacks
carles85435083car__les
carlines103521653carlines
carmaker1637313carmaker
carmakers1736923carmakers
carmines123617873carmines
carnage10311743carnage_
carnies94123963car_nies
caroaches1637793caroaches
caroches15710693caroches
carolers103314173carolers
carouses10614503carouses
carpale113414353carpale_
carpals113414633carpa_ls
carpers114521253carper_s
carports1238943carports
carracks1637713carracks
carrel84718633car__rel
carrels95117303car__rels
carriages1238333carriages
carriers103614203carriers
carries94328013car_ries
carrs75730853car__r_s
carses85233653car__ses
cartage10312593cartage_
carters95327253carter_s
cartes86239473car__tes
carvers124817543carver_s
carves115128453car__ves
carwashes1745783carwashes
cascades13128553cascades
cascaras1237703cascaras
caseases10410473caseases
caseates10313713caseates
catface1436763catface_
catfalls1347063catfalls
catharses1446413catharses
caudates11310263caudates
caviare1238373caviare_
caviars1238623caviar_s
centares102913893centares
cerates95428253cer_ates
charades141310853char_ades
charases131312763char_ases
chares115631803c__hares
claywares1743463claywares
compares143816433compares
cordages12310113cordages
corkages1539103corkages
corrades111211263corrades
corsages11310363corsages
crafters13419953crafters
crakes124921813c_r_akes
cranes84330753c_r_anes
crapes104727693c_r_apes
crases85532313c_r_ases
crates85736063c_r_ates
craves115825393c_r_aves
crazes174720133c_r_azes
creases94020963c_reases
creates95225203c_reates
crores86121163c_r_ores
curaras93911953cur_aras
curare84916953cur_are_
curaris94114773cur_aris
curates95323833cur_ates
czardases2143033czardases
darbars10510093darbar_s
daycares1454803daycares
daymares1445333daymares
earmarks1444793earmarks
earwaxes1844703earwaxes
fanfare1336673fanfare_
fares85852873___fares
farfals13268503farfa_ls
furfures1445663furfures
garages9314113gar_ages
garbages1238183garbages
hardwares1646563hardwares
infares10313023_infares
karates115617473kar_ates
narrates8312763narrates
parades104121463par_ades
parbakes1638343parbakes
parfaits1346913parfaits
parkades1538273parkades
partakes1449923partakes
parures9512693par_ures
rares55247443__r_ares
safaris101110663sa_faris
sarapes94617753sar_apes
sardars83112903sardar_s
sarsars73512143sarsar_s
scalares103210983sca_lares
scarfers13408463scarfer_s
serfages1238233serfages
surfaces1338673surfaces
taffarel1442563taffarel
taffarels1541863taffarels
tarres64723043tar__res
tartare73012683tartare_
tartars73313403tartar_s
urares64519093_ur_ares
variates111214983variates
warfarin1444983warfarin
warfarins1544733warfarins
warpages1437053warpages
wayfarer1742923wayfarer
wayfarers1842623wayfarers
welfares1445543welfares
wharfages1942633wharfages
workfares1943393workfares
yardages1336203yardages
yardarms14123333yardarms
zaffars22325233zaffar_s
zaffres22324993za_ffres

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622076.83021400.0
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.31224438.0
 
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.