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

138 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
tubular926747(None) 
tabular9279761tabular
tumular9236541tumular
cupular11317622cupular
fabular12288692fabular
fibular12267972fibular
jugular1534512jugular
lobular936662lobular
lunular736012lunular
mutular936642mutular
nebular956482nebular
pabular11259472pabular
subalar9118072subalar
tegular836602tegular
titular737522titular
tubularly1453152tubularly
tubulate1038272tubulate
tubulator1145022tubulator
tubule839852tubul_e
tubules9310232tubules
tubulin9116432tubulin
tubulure1042762tubulure
tutelar735372tutelar
uvular955562_uvular
alular6311353_alular
angular838533angular
annular737693annular
bolar75123473__bolar
bubbler103611783bubbler
bulbar1039583__bulbar
burglar1065533burglar
canular9310323canular
copular113810603copular
cupula10328433cupula_
cupulae11347853cupulae
facular122810443facular
fibula11258053fibula_
fibulae12237013fibulae
fibulas12228563fibulas
fubar1039923fub__ar
furcular1345703furcular
globular1143383globular
gular6314833__gular
hamular1236973hamular
insular7138703insular
jocular1637303jocular
jugula1434983jugula_
jugulars1643233jugulars
ligular8348533ligular
locular938953locular
lunula636173lunula_
lunulae735613lunulae
macular113011943macular
modular1087363modular
morular978223morular
muscular1246243muscular
nebula857333nebula_
nebulae955493nebulae
nebulas957583nebulas
neurular844003neurular
nodular876703nodular
nummular1242693nummular
ocular8610133_ocular
oscular937933oscular
ovular946833_ovular
papular11299763papular
pilular938203pilular
plumular1243303plumular
popular11319563popular
pupilar11125313pupilar
pustular1045153pustular
radular837833radular
ranular739433ranular
regular838423regular
rubeolar10153213rubeolar
secular92211533secular
simular938673simular
stipular1045843stipular
subadar10125573subadar
subclan1147173subclan
sublunar1044103sublunar
subpar1048663sub_par
subpolar1245183subpolar
subsolar1045113subsolar
subtler92910843subtler
subulate10312743subulate
tabla73318363tab_la_
tablas83716163tab_las
tabularly1443513tabularly
tabulate10310893tabulate
tabulator1145913tabulator
tabuli839363tabul_i
tabulis938833tabulis
talar56225383t__alar
templar1145643templar
tissular843813tissular
titulars845853titulars
titulary1144873titulary
tolar55524113t__olar
torula6610393torula_
torulae758553torulae
torulas759843torulas
tuba65422363tub__a_
tubae74716643tub__ae
tubal75517203tub__al
tubas75119573tub__as
tubber104313203tub_ber
tubbier11237743tubbier
tuber75420683tub__er
tubercular1452923tubercular
tubful1136683tubful__
tubfuls1245473tubful_s
tubulated1256063tubulated
tubulates1147233tubulates
tubulators1244503tubulators
tubulins10106293tubulins
tubulose1043893tubulose
tubulous1045363tubulous
tubulures1142613tubulures
tumbler113412823tumbler
tummler11266613tummler
tumuli835933tumul_i
tumult839703tumul_t
tumults934823tumults
tumulus935033tumulus
turbocar1243363turbocar
turtler72610323turtler
tussar6369543tu_ssar
tutelars844993tutelars
tutelary1143573tutelary
undular837123undular
ungular836773ungular
uvula845153_uvula_
uvulae945323_uvulae
uvulars1044413_uvulars
uvulas946523_uvulas
venular1037683venular
zonular1656493zonular

Search took 10 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.1561145455.1
2DLD Change Limit1340271389.00014891.9
3Display Results1381380.1101254.5
 (SQL Overall)1786911389.26619284.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.