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

195 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
tabular927977(None) 
fabular12288701fabular
pabular11259481pabular
tubular9267481tubular
alular6311362_alular
canular9310332canular
facular122810452facular
fibular12267982fibular
hamular1236982hamular
lobular936672lobular
macular113011952macular
nebular956492nebular
papular11299772papular
radular837842radular
ranular739442ranular
tabla73318362tab_la_
tablas83716162tab_las
tabularly1443512tabularly
tabulate10310892tabulate
tabulator1145922tabulator
tabuli839362tabul_i
tabulis938832tabulis
talar56225382ta__lar
tegular836602tegular
titular737522titular
tumular9236552tumular
abler75624313_ab_ler
abulia83512503_abulia
abulias93210703_abulias
abulic106411423_abulic
abuser85413683_abuser
acetabular1451733acetabular
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
angular838543angular
annular737703annular
ashlar9338203_ashlar
aurar54420253_a_urar
babbler104012823babbler
babul96317713babul__
babuls105413643babul_s
bacula103112693bacula_
basilar937313basilar
bolar75123473__bolar
bulbar1039583__bulbar
cabala103516913cabala_
cabalas113516003cabalas
cabler104519173cab_ler
cannular1046293cannular
canula8312973canula_
canulae9311193canulae
canulas9312863canulas
capsular1245413capsular
copular113810613copular
cupular11317633cupular
dabbler124012153dabbler
fabler116115813fab_ler
fabulate1339203fabulate
fabulator1445393fabulator
facula112912233facula_
faculae123210353faculae
fibula11258053fibula_
fibulae12237013fibulae
fibulas12228563fibulas
gabbler124013303gabbler
globular1143383globular
granular946903granular
gular6314833__gular
hauler95015123ha_uler
insular7138713insular
jaguar1435283jagu_ar
jocular1637313jocular
jugular1534523jugular
kabala124011553kabala_
kabalas133911063kabalas
kabar114815563kab__ar
labeler92310183labeler
lacunar9136293lacunar
ligular8348533ligular
locular938963locular
lunular736023lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443ma__lar
mauler84416713ma_uler
modular1087363modular
morular978223morular
mutular936653mutular
nebula857333nebula_
nebulae955493nebulae
nebulas957583nebulas
nodular876703nodular
ocular8610143_ocular
oracular1047543oracular
oscular937943oscular
ovular946833_ovular
pabulum1344473pabulum
papula103011123papula_
papulae11249363papulae
piacular1246583piacular
pilular938203pilular
planular1044763planular
popular11319573popular
qabala17399193qabala_
qabalah21285033qabalah
qabalas18289503qabalas
rabbler113514093rabbler
radula749313radula_
radulae837963radulae
radulas839583radulas
ranula6311813ranula_
ranulas7311783ranulas
regular838423regular
saccular1246903saccular
scapular1245383scapular
secular92211543secular
simular938683simular
spatular1044663spatular
stabler94014933stab_ler
stipular1045853stipular
subalar9118083subalar
tabard9313333tab__ard
taber73825823tab__er
table75429603tab_l_e
tableau966283tableau
tabled94020043tab_led
tables84524893tab_les
tablet84227643tab_let
tabor75518393tab__or
taborer9269293taborer
tabouleh1342793tabouleh
tabouli945843taboul_i
taboulis1045043taboulis
tabour84011323tab_our
tabourer1035743tabourer
tabu66328493tabu___
tabued94310403tabu_ed
tabuing10308893tabuing
tabulable1344043tabulable
tabulated1237303tabulated
tabulates1139143tabulates
tabulators1245293tabulators
tabun75914373tabu__n
tabuns8489223tabu_ns
tabus74820923tabu__s
tackler134013323tackler
tailer63823733ta_iler
tailor63412503ta_ilor
tala45938053ta__la_
talars66021683ta__lars
talas55935893ta__las
taler56034873ta__ler
taller63721963ta_ller
taluka10426773taluka_
talukas11316213talukas
tambala1138023tambala_
tambalas1237033tambalas
tambur10358713tambu__r
tambura11326463tambura_
tamburas12316053tamburas
tangler83515083tangler
tartar63214763ta_rtar
taskbar1393023taskbar
tatar56122063ta__tar
tattler73112213tattler
tauter64318023ta_uter
templar1145643templar
tissular843823tissular
titulars845863titulars
titulary1144873titulary
tolar55524113t__olar
torula6610393torula_
torulae758553torulae
torulas759853torulas
trabecular1453283trabecular
tubularly1453153tubularly
tubulate1038273tubulate
tubulator1145033tubulator
tubule839853tubul_e
tubules9310233tubules
tubulin9116433tubulin
tubulure1042773tubulure
tutelar735373tutelar
undular837133undular
ungular836783ungular
uvular955573_uvular
vacuolar1353483vacuolar
valvular1443473valvular
vascular1346303vascular
venular1037683venular
vocabular1652173vocabular
wabbler143511923wabbler
zonular1656493zonular

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271956.97019229.1
3Display Results1951950.0762565.8
 (SQL Overall)1786911957.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.