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

279 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
chakras1642850(None) 
chakra15437531chakra_
charas114223611cha_ras
charkas164810961charkas
bhaktas1633642bhaktas
chacmas1638002chacmas
chadars1338292chadars
chairs114916182chair_s
challas124414122challas
chards125119732cha_rds
chares115631802cha_res
charka154011702charka_
charkhas20285022charkhas
charks155219702cha_rks
charms135218842cha_rms
charros124312142charros
charrs115219192cha_rrs
chars105936642cha_r_s
charts115823092cha_rts
chukars1634282chukars
chukkas1532782chukkas
abakas123911743abak_as
arras55626133__arras
auras55932553__auras
bhakta1533653bhakta_
bhaktis1633433bhaktis
bhangras1443693bhangras
bharal1138893bha_ral
bharals1236733bha_rals
buckras1537343buckras
cacas95627983c_a_cas
cadres94017933c_adres
cairds96411513c_airds
cairns85313303c_airns
cakes116037673c_ak_es
callas84526753c_allas
camas96333523c_a_mas
cameras11313363cameras
cannas84518403c_annas
canvas113813333c_anvas
capias10318353c_apias
capris10415083c_apris
carat75048793c_a_rat
carats85929023c_a_rats
carbs96031463c_a_rbs
cards85137933c_a_rds
cares77369183c_a_res
carks115534213c_a_rks
carls77037423c_a_rls
carns75937563c_a_rns
carps96932253c_a_rps
carrs75730853c_a_rrs
cars67364763c_a_r_s
carts78946293c_a_rts
casas75327843c_a_sas
cesuras958693cesuras
chablis14368563chablis
chabuks1843733chabuks
chachkas22173733chachkas
chacma1537903chacma_
chadar1239353cha_dar
chadors1338753chadors
chadri1238143chadr_i
chads116122233cha__ds
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chafers154512743chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chagrin1337893chagrin
chagrins1437073chagrins
chaines124518733chaines
chains114819703cha_ins
chair105519633chair__
chaired134211243chaired
chairman15106383chairman
chairmans1685143chairmans
chais107530313cha__is
chaises124317493chaises
chalah143511663cha_lah
chalahs15289883chalahs
chalazas2245893chalazas
chalehs15268803chalehs
chalets122813473chalets
chalks155412143cha_lks
challa114014193challa_
challah15458323challah
challahs16377563challahs
challis124613463challis
chalupas1554383chalupas
chambray2043143chambray
chambrays2142423chambrays
chamisa14328853chamisa
chamisas15317813chamisas
chamois143512193chamois
champac1834953champac
champacs1934633champacs
champak2034493champak
champaks2134103champaks
champs154915683cha_mps
chams126028503cha__ms
chances145218093chances
chancres15429363chancres
changes134517583changes
changs125215373cha_ngs
chants115020393cha_nts
chaos105622863cha__os
chaoses124715123chaoses
chapeau1435523chapeau
chapeaus1544993chapeaus
chapels14429153chapels
chapes135421873cha_pes
chapman1637893chapman
chaps125326063cha__ps
char95132153cha_r__
charade13129913cha_rade
charades141310853cha_rades
charases131312763cha_rases
chard116124743cha_r_d
chare105231983cha_r_e
chared125423693cha_red
charge125114213cha_rge
charges134615983charges
charism14712203cha_rism
chark144222713cha_r_k
charked174814013charked
charkha19405153charkha
charm126124663cha_r_m
charpai1436633charpai
charpais1536933charpais
charr104821783cha_r_r
charred134614483charred
charro114212953cha_rro
charry145012113cha_rry
chart105038283cha_r_t
chary135023133cha_r_y
chasers123714923chasers
chases115128233cha_ses
chasmal14158213chasmal
chasms135513143cha_sms
chasses124017503chasses
chassis123910663chassis
chateau1236273chateau
chateaus1346013chateaus
chats105730093cha__ts
chaunts1267083chaunts
chawers154412053chawers
chaws135022463cha__ws
chays135319743cha__ys
chazan20269133cha_zan
chazans21268123chazans
chazzan20204853chazzan
chazzans21234503chazzans
cheeros123711633cheeros
cheers114518913cheer_s
chelas113817203ch_elas
cherts115617233ch_erts
chevres15379793chevres
chias104625523ch__ias
chiasmas15306593chiasmas
chicas135916473ch_icas
chimaeras1664573chimaeras
chimars144010593chimars
chimeras15388833chimeras
chimlas1437453chimlas
chinas115119403ch_inas
chiral114614413ch_iral
chirks155414843ch_irks
chirms135113983ch_irms
chiros114617773ch_iros
chirps135414003ch_irps
chirres123812253chirres
chirrs114514983ch_irrs
chirus114615693ch_irus
chloral12169983chloral
chlorals13148033chlorals
choirs114911883choir_s
chokers164311523chokers
chokes154917383chok_es
cholas114818003ch_olas
choleras13289043choleras
chollas123811353chollas
choral115118493ch_oral
chorals124614113ch_orals
chords125214633ch_ords
choreas124414203choreas
chores114828023ch_ores
chorus115014773ch_orus
chromas142512693chromas
chufas14397673ch_ufas
chukar1534633chuk_ar
chukka1433013chukka_
chukkar1542053chukkar
chukkars1642013chukkars
chuppas1644123chuppas
churls115411073ch_urls
churns114910233ch_urns
churros12427583churros
churrs115111513ch_urrs
citharas13156723citha_ras
clarkias1444793clarkias
claros84015113cla_ros
coalas87418963coa_las
cobras104014193c_obras
contras93015623contras
coppras13327833coppras
copras103517153c_opras
crakes124921813crak_es
cuatros938273cuatros
curaras93911953curaras
czardas1934673czardas
czars164812913cza_r_s
dhaks13479703dhak__s
dharmas1356513dharmas
dharnas1155373dharnas
dhooras1135943dhooras
echards1337963echa_rds
gharris11306433gharris
haars85620473_haar_s
haeres94017033_haeres
hahas117118443_ha_has
hairs86225173_hair_s
hakes126034303_hak_es
hakims1537303_hakims
hakus125114113_hak_us
halmas117017893_halmas
halvas124714173_halvas
hamzas20119013_hamzas
hansas94616043_hansas
harass9313943_ha_rass
hards96435653_ha_rds
hares86255543_ha_res
harks126333433_ha_rks
harls85634503_ha_rls
harms106829013_ha_rms
harps105926873_ha_rps
harts88441593_ha_rts
hijras1635773_hijras
horas86333103_h_oras
hydras13239313_hydras
jagras1438463_jagras
kakas85117343_kak_as
khakis1265853khak_is
lauras63414333_lauras
madras94316433_madras
makars124612633_makars
maras75443283_ma_ras
markas124717003_markas
nairas6312783_nairas
nakfas1334683_nakfas
okras94410973__okras
pakoras1337473_pakoras
paras76143043_pa_ras
parkas125018023_parkas
pharos11312063pha_ros
sabras85116363_sabras
shairds11216263shairds
shairns10276783shairns
shakers144015563shakers
shakes135024593shak_es
shakoes144510023shakoes
shakos134912193shak_os
shamas113717943sha_mas
shammas14358723shammas
shards104319173sha_rds
shares95236413sha_res
sharias102516003sharias
sharks135019723sha_rks
sharns95516983sha_rns
sharps115516083sha_rps
shikars1436183shikars
shiksas1484643shiksas
takas95520683_tak_as
thairms1244453thairms
tharms115712243tha_rms
tiaras6314553tia_ras
varas86028193_va_ras
wharfs1546373wha_rfs

Search took 7 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.1401276364.3
2DLD Change Limit1340272795.78023188.1
3Display Results2792790.0962906.3
 (SQL Overall)1786912796.01629702.6
 
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.