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

126 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
kbar10651465(None) 
bar58070551_bar
kabar114815551kabar
kbars114612601kbars
kebar115113531kebar
knar85818721knar
kyar116916841kyar
aba512850952aba_
abas68642082abas
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
ba49962342_ba_
baa510650422_baa
bad67763152_bad
bag67059222_bag
bah87755352_bah
bal56662722_bal
bam78560142_bam
ban58366832_ban
bap76455842_bap
barb85240062_barb
bard75648862_bard
bare65460522_bare
barf95844412_barf
bark106242152_bark
barm86739602_barm
barn66444642_barn
bars66564092_bars
bas58681752_bas
bat510988952_bat
bay89661642_bay
bear66844642bear
boar66134292boar
bra56339462_bra
brr56921922_brr
bur55744692_bur
car59165562_car
char95132152char
czar156013132czar
dear55343602dear
debar85517862debar
ear36867882_ear
embar94011602embar
far67762602_far
fear75337792fear
fiar76427332fiar
fubar1039922fubar
gar47259902_gar
gear55934972gear
gnar56021382gnar
guar56923292guar
haar77323492haar
hear76143882hear
hoar76729162hoar
izar136616012izar
jar107646152_jar
ka69145082k_a_
kaas86531842kaas
kab97145852k_ab
kabab134814442kabab
kabars124513952kabars
kabs107130842kabs
kae76744542k_ae
kaf106845512k_af
karn86129412k_arn
kart86750802k_art
kas77058582k_as
kat77468292k_at
kay106745542k_ay
kea76540912kea_
keas86337092keas
kebab134312002kebab
kebars124112492kebars
keir86217872keir
khaf145319602khaf
khan115819142khan
khat116730722khat
kier86526802kier
kir76535672k_ir
knap105815402knap
knars94416112knars
knaur9508252knaur
knur85311972knur
koa76737772koa_
koan85425032koan
koas85635092koas
kor76538892k_or
kora86431552kora
kvas117015942kvas
kyak105213632kyak
kyars124813962kyars
kyat116025522kyat
lar37967532_lar
lear47045952lear
liar47229682liar
lobar7313012lobar
maar66025052maar
mar57965942_mar
near45236502near
oar37057952_oar
oba57531552oba_
obas65730932obas
osar46820952osar
par57467022_par
pear69745232pear
rear45644552rear
rebar75420192rebar
roar46328572roar
scar66434202scar
sear47353842sear
soar46838672soar
spar65433302spar
star48037762star
tar37570692_tar
tear45242882tear
tsar47819802tsar
tzar136315372tzar
unbar71913612unbar
var66148332_var
war67262422_war
wear75836722wear
yar67253832_yar
year76534252year

Search took 1 second 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.0802233637.5
2DLD Change Limit298721260.85634897.2
3Display Results1261260.0167875.0
 (SQL Overall)1786911260.952187700.6
 
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.