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

143 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
kiblah153558(None) 
keblah1545311keblah
kibla1139831kibla_
kiblahs1634151kiblahs
kiblas1239321kiblas
blah98625062__blah
keblahs1634562keblahs
kibbeh17406062kibbeh
kibosh1534262kibosh
liblab1035082liblab
zillah1836562zillah
bah87755353__b_ah
bible95119413bibl_e
bibles104617643bibles
bimah127013263bi_mah
blab86629133__blab
blae66134643__blae
blahs105616513__blahs
blam86131703__blam
blat66550953__blat
blaw97026723__blaw
chalah143511653chalah
dobla84913643dobla_
doblas93812293doblas
fellah124910773fellah
fibula11258053fibula_
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
fila74729133fi_la_
filar84819293fi_lar
filch134813323fi_lch
filth115015823fi_lth
galah95917623_galah
giblet93418893giblet
hallah124115403hallah
hijrah1934273hijrah
hila76228353hi_la_
hilar85418143hi_lar
inlay85214323_inlay
jubbah2034353jubbah
jubhah2142803jubhah
kabab134814433kab_ab
kabala124011553kabala
kabalas133911063kabalas
kabar114815553kab_ar
kabbalah1962433kabbalah
kalam11315113k_alam
kasbah1535183kasbah
kbar106514653k_b_ar
kebab134311993keb_ab
kebar115113533keb_ar
keddah1534263keddah
khedah1743643khedah
khirkah1641423khirkah
kiaugh1442813kiaugh
kibbe135211963kib_be
kibbehs18354183kibbehs
kibbes143811193kibbes
kibbi13449263kib_bi
kibbis14398463kibbis
kibble143910953kibble
kibbled16367983kibbled
kibbles153510253kibbles
kibe106523433kib__e
kibei114311533kib_ei
kibeis12469803kibeis
kibes115521113kib_es
kibitz2177633kibitz
kidnap1334193kidnap
kilim11711883ki_lim
kill85533173ki_l_l
killed113918773killed
killer104917953killer
killie104114893killie
kills94526173ki_lls
kiln85620973ki_l_n
kilns95112983ki_lns
kilo86028663ki_l_o
kilos95021473ki_los
kilt86144413ki_l_t
kilts95122183ki_lts
kilty125213893ki_lty
kina85631993ki_na_
kinas95626913ki_nas
kirsch1532713kirsch
kismat123011673kismat
kitbag1334973kitbag
kith115826353ki__th
kitsch1533353kitsch
kiva116516403ki_va_
kivas124614733ki_vas
koala95112213koala_
koalas104011663koalas
kola85124963k_ola_
kolas94822233k_olas
kulak858823k_ulak
kybosh1842713kybosh
liblabs1144123liblabs
libra74712423libra_
librae84310173librae
libras83711703libras
lilac7311073li_lac
mikvah18143473mikvah
milch124413373mi_lch
mislay113510683mislay
mollah11319453mollah
moolah11409193moolah
mullah113710733mullah
nullah9388143nullah
obeah1038993_obeah
pibal95217323pib_al
pibals103813083pibals
pilaf103923483pi_laf
pilar75221503pi_lar
pilau73618523pi_lau
pilaw103913743pi_law
pillar8314023pillar
qabalah21285033qabalah
ribald9209293ribald
riblet84222443riblet
selah8319613_selah
shibah14387463shib_ah
sigla64515203sigla_
sirrah9379753sirrah
subah106015213sub_ah
tabla73318363tabla_
tablas83716163tablas
tibia7312393tibia_
tibiae838473tibiae
tibial849833tibial
tibias839943tibias
tilak91011553ti_lak
tilth85515363ti_lth
villa85321233villa_
villae95615383villae
villas96117263villas
viola85915543viola_
violas93713523violas
wallah124011993wallah
zibeth2034173zibeth
zilch19438123zi_lch
zillahs1935383zillahs

Search took 6 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.1431249587.4
2DLD Change Limit1127161435.37320978.2
3Display Results1431430.0334333.3
 (SQL Overall)1786911435.54932202.4
 
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.