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

237 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
chare10523198(None) 
care66968371c_are
chafe135117351chafe
chape125221141chape
char95132151char_
chard116124741chard
chared125423691chared
chares115631801chares
charge125114211charge
chark144222711chark
charm126124661charm
charr104821781charr
chars105936631chars
chart105038281chart
chary135023131chary
chase105127121chase
chore105126761chore
hare76255731_hare
share86437081share
are37874572__are
aware86420022aware
bare65460522_bare
blare75826232blare
cade76443912c_ade
cadre85419012cadre
cafe95230322c_afe
cage75339062c_age
cake105439962c_ake
came87648752c_ame
cane66653112c_ane
cape87242782c_ape
car59165562c_ar_
carb85143162c_arb
card710245872c_ard
cared86050092c_ared
carer74942332c_arer
cares77369182c_ares
caret75360562c_aret
carex144822292c_arex
cark105539272c_ark
carl65144782c_arl
carle74535702c_arle
carn66245432c_arn
carp85139812c_arp
carr65434702c_arr
cars67364762c_ars
carse74934332c_arse
cart66570342c_art
carte75940422c_arte
carve106227752c_arve
case65848082c_ase
cate66254592c_ate
cave95941262c_ave
cease75227652cease
cere66741472c_ere
chad105525502cha_d
chadri1238132chadri
chads116122232chads
chafed154813912chafed
chafer144714572chafer
chafes145017912chafes
chaff165016282chaff
chai95929902cha_i
chain105723672chain
chaine115119222chaine
chair105519632chair
chaired134211242chaired
chairs114916172chairs
chais107530312chais
chaise114916412chaise
chakra15437532chakra
chaleh143711992chaleh
chalet113825992chalet
chalk144814602chalk
cham115532312cha_m
champ145017962champ
chams126028502chams
chance134617092chance
chancre14348782chancre
chang115418562chang
change124116752change
chant105932692chant
chao95727312cha_o
chaos105622862chaos
chap114928492cha_p
chapel134911372chapel
chapes135421872chapes
chaps125326062chaps
chapt125827642chapt
charade13129902charade
charas114223592charas
chards125119722chards
charged144614022charged
charger133914062charger
charges134615982charges
charier124317902charier
charka154011702charka
charked174814012charked
charks155219702charks
charley15118272charley
charlie123011922charlie
charmed154714242charmed
charmer144913662charmer
charms135218832charms
charnel124010052charnel
charred134614482charred
charro114212952charro
charrs115219182charrs
charry145012112charry
charted135116852charted
charter123918302charter
charts115823092charts
chased125019292chased
chaser114918382chaser
chases115128232chases
chasm125518792chasm
chasse115114602chasse
chaste114617392chaste
chat95546132cha_t
chats105730092chats
chaw126224632cha_w
chawed155214602chawed
chawer144314412chawer
chaws135022462chaws
chay124924872cha_y
chays135319742chays
cheer105420382cheer
chert105232102chert
chevre14318312chevre
chide115321012chide
chile105626892chile
chime125322592chime
chine105231722chine
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chirre114111852chirre
chiru105317152chiru
chive135117622chive
choke145118022choke
chord115917262chord
chorea115216082chorea
chored125321882chored
chores114828022chores
chose105925402chose
churl105913882churl
churn105113102churn
churr104512852churr
chute104316462chute
chyle134913482chyle
chyme156512502chyme
cire65836372c_ire
clade85821012clade
claret84026572claret
claro75018692claro
clary105719612clary
clave105420152clave
coarse84813892coarse
cohere112716992cohere
core67263112c_ore
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
crore74922862crore
curare84916952curare
cure66149122c_ure
czar156013132czar_
czars164812912czars
dare55848862_dare
echard1249222echard
fare76354462_fare
flare84823632flare
glare65222952glare
hade85440192_hade
hae67364002_ha_e
hake115637842_hake
hale76052832_hale
hame97043132_hame
hard85443502_hard
hared95742182_hared
harem104924452_harem
hares86255542_hares
hark115237392_hark
harl75740002_harl
harm95637792_harm
harp96134282_harp
hart76865772_hart
hate78450172_hate
have106137072_have
haze164833392_haze
here76447102_here
hire75538962_hire
mare64759322_mare
ochre103411592och_re
pare66760842_pare
phage115113672phage
phase104617212phase
quare143920542quare
rare45348432_rare
scare75334462scare
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shave114425892shave
shire84727132shire
shore85432642shore
snare54429982snare
spare75135562spare
stare54440262stare
sware85828212sware
tare45957622_tare
thae76825562tha_e
thane86122532thane
tharm105916642tharm
there87527392there
urare56322552urare
ware76254722_ware
whale115517432whale
wharf14315822wharf
wharve15456202wharve
where117019422where
whore116018042whore
yare75636942_yare

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 Filter178691538000.0931921408.6
2DLD Change Limit538002371.90628226.7
3Display Results2372370.0802962.5
 (SQL Overall)1786912372.07985950.5
 
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.