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 “keblah” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
keblah154531(None) 
keblahs1634561keblahs
kiblah1535581kiblah
blah98625062__blah
fellah124910772fellah
kebab134312002keb_ab
kebar115113532keb_ar
keddah1534272keddah
kibla1139832kibla_
kiblahs1634152kiblahs
kiblas1239322kiblas
selah8319612se_lah
akela9311343ake_la_
akelas10311193ake_las
bah87755353__b_ah
bedlam1149273bedlam
beflag1265883beflag
beglad10138463beglad
belay105021523be_lay
belch124415503be_lch
blab86629133__blab
blae66134643__blae
blahs105616513__blahs
blam86131703__blam
blat66550953__blat
blaw97026723__blaw
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
chalah143511663chalah
debag94212303deb_ag
debar85517863deb_ar
debeak1336763debeak
declaw1266703declaw
delay94820633de_lay
dewlap1264843dewlap
dobla84913643dobla_
doblas93812293doblas
eclat7523603_eclat
elan46734243_e_lan
ephah1337063_ephah
fella84918653fella_
fellahs13428393fellahs
fellas95116963fellas
galah95917633_galah
gerah9315303ge_rah
hallah124115403hallah
health124712143health
jetlag1434523jetlag
jubbah2034353jubbah
jubhah2142803jubhah
kabab134814443kab_ab
kabala124011553kabala
kabalas133911063kabalas
kabar114815553kab_ar
kabbalah1962433kabbalah
kalam11315113k_alam
kasbah1535183kasbah
kbar106514653k_b_ar
kea76540913ke__a_
keas86337093ke__as
kebabs14418513kebabs
kebars124112493kebars
kebbie1435813kebbie
kebob135110923keb_ob
kebobs14427293kebobs
keddahs1642923keddahs
keel85729473keel__
keelage1236183keelage
keeled114414273keeled
keels94622413keel_s
kegler11398243kegler
kelep116014563ke_lep
kelim11912553ke_lim
kelly124617023ke_lly
kelp105322803ke_l_p
kelps115116423ke_lps
kelpy145110683ke_lpy
kelt85343193ke_l_t
kelts95222633ke_lts
kenaf12316033ke_naf
kench145513923ke_nch
ketch144912023ke_tch
keypad1633823keypad
keypal1534893keypal
keyway1943823keyway
khedah1743643khedah
kibbeh17406063kibbeh
kibosh1534263kibosh
koala95112213koala_
koalas104011663koalas
kola85124963k_ola_
kolas94822233k_olas
kreplach1942613kreplach
kulak858823k_ulak
kybosh1842713kybosh
liblab1035083liblab
medlar93010463medlar
mollah11319453mollah
moolah11409193moolah
mullah113710733mullah
nebula857333nebula_
nebulae955493nebulae
nebular956483nebular
nebulas957583nebulas
nullah9388143nullah
obeah1038993_obeah
pedlar93311273pedlar
pepla9312863pepla_
qabalah21285033qabalah
rebar75420193reb_ar
reclad9311873reclad
reflag1098083reflag
relax124817803re_lax
relay84424673re_lay
replan83215823replan
replay113412923replay
selahs9313213se_lahs
subah106015213sub_ah
tabla73318363tabla_
tablas83716163tablas
tela45532973te_la_
telae54323293te_lae
tesla55612603tesla_
teslas64212173teslas
vela75725543ve_la_
velar85817633ve_lar
wallah124011993wallah
wealth12379223wealth
webcam1545543webcam
weblog1234223weblog
welch134411493we_lch
welsh113110363we_lsh
yeah106725413ye__ah
zebra1637883zebra_
zebras1737853zebras
zillah1836563zillah

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161375.95318934.3
3Display Results1371370.0801712.5
 (SQL Overall)1786911376.40927881.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.