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

130 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
czar15601313(None) 
car59165561c_ar
char95132151char
czars164812911czars
izar136616011izar
tzar136315371tzar
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
azan136521782azan
bar58070552_bar
bazar163816002bazar
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
chad105525502chad
chai95929902chai
chair105519632chair
cham115532312cham
chao95727312chao
chap114928492chap
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
chars105936632chars
chart105038282chart
chary135023132chary
chat95546132chat
chaw126224632chaw
chay124924872chay
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
dear55343602dear
ear36867882_ear
far67762602_far
fear75337792fear
fiar76427332fiar
gar47259902_gar
gazar154612982gazar
gear55934972gear
gnar56021382gnar
guar56923292guar
haar77323492haar
hear76143882hear
hoar76729162hoar
izars145112932izars
jar107646152_jar
kbar106514652kbar
knar85818722knar
kyar116916842kyar
lar37967532_lar
lazar144113642lazar
lear47045952lear
liar47229682liar
maar66025052maar
mar57965942_mar
near45236502near
oar37057952_oar
osar46820952osar
par57467022_par
pear69745232pear
rear45644552rear
roar46328572roar
scar66434202scar
sear47353842sear
sizar145214992sizar
soar46838672soar
spar65433302spar
star48037762star
tar37570692_tar
tear45242882tear
tsar47819802tsar
tzars144914272tzars
var66148332_var
war67262422_war
wear75836722wear
yar67253832_yar
year76534252year
za1114939202_za_
zag137539472_zag
zap145840692_zap
zarf166929122_zarf
zas126946832_zas
zax197630632_zax

Search took 4 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.1561145455.1
2DLD Change Limit298721303.0939657.9
3Display Results1301300.0931397.8
 (SQL Overall)1786911303.34253468.3
 
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.