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

256 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
char9513215(None) 
car59165561c_ar
chad105525501chad
chai95929901chai
chair105519631chair
cham115532311cham
chao95727311chao
chap114928491chap
chard116124741chard
chare105231981chare
chark144222711chark
charm126124661charm
charr104821781charr
chars105936631chars
chart105038281chart
chary135023131chary
chat95546131chat
chaw126224631chaw
chay124924871chay
czar156013131czar
afar76720782afar
agar58726412agar
aha611246642aha_
ajar116217702ajar
alar46340072alar
ar211379382__ar
bar58070552_bar
bear66844642bear
boar66134292boar
cab78355402c_ab
cad67456362c_ad
cam78058982c_am
can57760132c_an
cap76758982c_ap
carb85143162c_arb
card710245872c_ard
care66968372c_are
cark105539272c_ark
carl65144782c_arl
carn66245432c_arn
carp85139812c_arp
carr65434702carr
cars67364762c_ars
cart66570342c_art
cat58282342c_at
caw86647932c_aw
cay87155982c_ay
cedar84014322cedar
chadar1239342chadar
chador1238662chador
chadri1238132chadri
chads116122232chads
chafe135117352chafe
chafer144714572chafer
chaff165016282chaff
chain105723672chain
chairs114916172chairs
chais107530312chais
chakra15437532chakra
chalk144814602chalk
champ145017962champ
chams126028502chams
chang115418562chang
chant105932692chant
chaos105622862chaos
chape125221142chape
chaps125326062chaps
chapt125827642chapt
charas114223592charas
chards125119722chards
chared125423692chared
chares115631802chares
charge125114212charge
charka154011702charka
charks155219702charks
charms135218832charms
charro114212952charro
charrs115219182charrs
charry145012112charry
charts115823092charts
chase105127122chase
chaser114918382chaser
chasm125518792chasm
chats105730092chats
chawer144314412chawer
chaws135022462chaws
chays135319742chays
cheap126915942cheap
cheat105732452cheat
cheer105420382cheer
chef125125622chef
chert105232102chert
chew126622132chew
chez184519022chez
chi86228652ch_i
chia96026622chia
chiao105618362chiao
chias104625512chias
chic115925202chic
chid106626402chid
chimar133911462chimar
chin96934742chin
chip116726422chip
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chiru105317152chiru
chis95933312chis
chit96937462chit
choir105313592choir
chon96627792chon
chop116024922chop
chord115917262chord
chore105126762chore
chow125820992chow
chub115516412chub
chug105914112chug
chukar1534632chukar
chum116318002chum
churl105913882churl
churn105113102churn
churr104512852churr
ciao64924182ciao
cigar8911792cigar
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
claro75018692claro
clary105719612clary
claw95624342claw
clay95927412clay
clear76219052clear
coal66939252coal
coat67558342coat
coax136922972coax
coir66327242coir
cor59960942c_or
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
cur56841982c_ur
curr65429652curr
cyan96419622cyan
cymar125711262cymar
czars164812912czars
dear55343602dear
dhak125512032dhak
dhal86719282dhal
ear36867882_ear
echard1249222echard
eschar1136522eschar
far67762602_far
fear75337792fear
fiar76427332fiar
gar47259902_gar
gear55934972gear
ghat86435282ghat
gnar56021382gnar
guar56923292guar
ha510259942_ha_
haar77323492haar
had77658762_had
hae67364002_hae
hag77255742_hag
hah910655222_hah
hair76330142_hair
haj138140602_haj
ham86363282_ham
hao67251122_hao
hap87360052_hap
hard85443502_hard
hare76255732_hare
hark115237392_hark
harl75740002_harl
harm95637792_harm
harp96134282_harp
hart76865772_hart
has67372652_has
hat67289962_hat
haw97153272_haw
hay97358772_hay
hear76143882hear
her66547812_her
hoar76729162hoar
ichor1039472ichor
izar136616012izar
jar107646152_jar
kbar106514652kbar
khaf145319602khaf
khan115819142khan
khat116730722khat
knar85818722knar
kyar116916842kyar
lahar83114262lahar
lar37967532_lar
lear47045952lear
liar47229682liar
maar66025052maar
mar57965942_mar
near45236502near
oar37057952_oar
ocher104516102ocher
osar46820952osar
par57467022_par
pear69745232pear
phat95837862phat
rear45644552rear
roar46328572roar
scar66434202scar
schav1338312schav
sear47353842sear
sha69837782sha_
shad86230912shad
shag86430562shag
shah105627782shah
sham96436352sham
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456592shat
shaw108132552shaw
shay107133342shay
shear85424832shear
soar46838672soar
spar65433302spar
star48037762star
tahr75217152tahr
tar37570692_tar
tear45242882tear
thae76825562thae
than76128772than
tharm105916642tharm
that75639322that
thaw107521312thaw
thir76420542thir
tsar47819802tsar
tzar136315372tzar
var66148332_var
war67262422_war
wear75836722wear
wha96422072wha_
wham125321692wham
whap125119642whap
wharf14315822wharf
what105434072what
whir105519282whir
yar67253832_yar
year76534252year

Search took 2 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 Filter178691298720.1101624463.6
2DLD Change Limit298722561.03328917.7
3Display Results2562560.0932752.7
 (SQL Overall)1786912561.236144572.0
 
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.