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

122 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
kbars11461260(None) 
bars66564091_bars
kabars124513951kabars
kbar106514651kbar_
kebars124112491kebars
knars94416111knars
kyars124813961kyars
abas68642082aba_s
afars85716512afars
agars66120642agars
ars37670932__ars
baas66844672_baas
bads77048862_bads
bags76645502_bags
bals66354042_bals
bams87044452_bams
bans66555132_bans
baps86040842_baps
bar58070552_bar_
barb85240062_barb
barbs95928192_barbs
bard75648862_bard
bards87139642_bards
bare65460522_bare
bares75457132_bares
barf95844412_barf
barfs104826002_barfs
bark106242152_bark
barks115735812_barks
barm86739602_barm
barms96128462_barms
barn66444642_barn
barns76335142_barns
bas58681752_ba_s
bass66146782_bass
bats66962332_bats
bays97143912_bays
bears75739042bears
boars75229602boars
bras65746452_bras
burs65847422_burs
cars67364762_cars
chars105936642chars
czars164812912czars
dears65736882dears
debars94218042debars
ears46356592_ears
embars103812882embars
fears84829392fears
fiars86720832fiars
gars55750742_gars
gears64628692gears
gnars66718852gnars
guars65021052guars
haars85620472haars
hears86737372hears
hoars85925552hoars
izars145112932izars
jars117338352_jars
kaas86531842k_aas
kababs14409772kababs
kabar114815552kabar_
kabs107130842k_abs
kaes85734062k_aes
kafs116423742k_afs
karn86129412k_arn
karns96624142k_arns
karst97228992k_arst
kart86750802k_art
karts97630112k_arts
kas77058582k_a_s
kats85944332k_ats
kays116032192k_ays
keas86337092kea_s
kebabs14418512kebabs
kebar115113532kebar_
keirs95313672keirs
khafs15648842khafs
khans124615172khans
khats125316012khats
kiers95320092kiers
kirs85831732k_irs
knaps115511172knaps
knar85818722knar_
knaurs10466962knaurs
knurs94511152knurs
koans95818622koans
koas85635092koa_s
koras95927112koras
kors85933012k_ors
kvas117015942kva_s
kvass12507272kvass
kyaks11459162kyaks
kyar116916842kyar_
kyats125012442kyats
lars46956572_lars
lears55938732lears
liars54723162liars
maars74621632maars
mars66261862_mars
nears55529422nears
oars46846032_oars
obas65730932oba_s
pars67560792_pars
pears75138612pears
rears54739652rears
rebars84019832rebars
roars55622242roars
scars75433532scars
sears54744912sears
soars54732512soars
spars75431542spars
stars55836572stars
tars46763952_tars
tears55436462tears
tsars56717112tsars
tzars144914272tzars
unbars82113032unbars
vars75742072_vars
wars78659802_wars
wears86030302wears
years84527672years

Search took 5 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 Limit538001224.39312246.8
3Display Results1221220.1061150.9
 (SQL Overall)1786911224.59238913.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.