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

179 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
ranular73944(None) 
canular9310331canular
granular946901granular
radular837841radular
ranula6311811ranula_
ranulas7311781ranulas
alular6311362_alular
angular838542_angular
annular737702annular
cannular1046292cannular
canula8312972canula_
canulae9311192canulae
canulas9312862canulas
fabular12288702fabular
facular122810452facular
frenular1144632frenular
hamular1236982hamular
lunular736022lunular
macular113011952macular
oracular1047542oracular
pabular11259482pabular
papular11299772papular
planular1044762planular
radula749312radula_
radulae837962radulae
radulas839582radulas
regular838422regular
tabular9279772tabular
venular1037682venular
zonular1656492zonular
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
anear55420323_an_ear
angler74017863_angler
anlas55626933_an_las
anovular1144163_anovular
antiar6317173_antiar
antler64615553_antler
anural65714743_anural
anuran64313243_anuran
areolar779223areolar
ashlar9338203_ashlar
aurar54420253_a_urar
bacula103112693bacula_
basilar937313basilar
candler103516593candler
canicular1346473canicular
cannula937443cannula_
cannulae1046503cannulae
cannulas1037593cannulas
canola8313623canola_
canolas9313993canolas
canulate10314553canulate
capsular1245413capsular
cingular11256983cingular
consular1038823consular
copular113810613copular
cupular11317633cupular
dandler94414273dandler
dangler96912813dangler
facula112912233facula_
faculae123210353faculae
fibular12267983fibular
frenula1045623frenula_
gangliar1064123gangliar
glandular1142793glandular
granola837913granola_
granolas938063granolas
granulate1059183granulate
granulator1155103granulator
granule839473granul_e
granules939943granules
gular6314833__gular
handcar1337373handcar
handler113516163handler
hangar104114523han_gar
hanuman1237133hanuman
hauler95015123ha_uler
insular7138713insular
jaguar1435283jagu_ar
jangler153811833jangler
jocular1637313jocular
jugular1534523jugular
kantar10311163kan_tar
lacunar9136293lacunar
landler84113203landler
ligular8348533ligular
lingular9407503lingular
lobular936673lobular
locular938963locular
lunula636173lunula_
lunulae735613lunulae
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443ma__lar
mangler103215643mangler
manila84518303manila_
manilas93915873manilas
manipular1344233manipular
manual8313463manu_al
manuals9311223manuals
manuary1237773manu_ary
manurer938583manurer
mauler84416713ma_uler
modular1087363modular
morular978223morular
mutular936653mutular
nebular956493nebular
nodular876703nodular
ocular8610143_ocular
oscular937943oscular
ovular946833_ovular
papula103011123papula_
papulae11249363papulae
pendular1144943pendular
piacular1246583piacular
pilular938203pilular
pinnular1044433pinnular
planula935773planula_
planulae1044793planulae
popular11319573popular
rabbler113514093rabbler
radar61316723ra__dar
radicular1245883radicular
raffler13339223raffler
raglan73711503ra_glan
railcar945483railcar
railer64524933ra_iler
rainwear1143113rainwear
rambla103510933rambla_
ramblas112710263ramblas
rambler113313263rambler
rancher123013633rancher
rancor8810373ran_cor
rancour987133rancour
randan7315253ran_dan
randier83618473randier
ranger73925533ran_ger
rangier83714353rangier
ranker105021903ran_ker
rankle103414883rankl_e
rankled123910653rankled
rankles113114553rankles
rankly133910453rankl_y
ranter63826823ran_ter
rattler74012743rattler
raveler104212463raveler
regulars936253regulars
retinular944763retinular
ruler54923343r__uler
saccular1246903saccular
sandbar10108193sandbar
sangar73617693san_gar
sansar63613403san_sar
scapular1245383scapular
secular92211543secular
simular938683simular
singular9327573singular
spatular1044663spatular
talar56225383ta__lar
tangler83515083tangler
tegular836603tegular
titular737523titular
triangular1162873triangular
tubular9267483tubular
tumular9236553tumular
undular837133undular
ungular836783ungular
uvular955573_uvular
vacuolar1353483vacuolar
valvular1443473valvular
vascular1346303vascular
wangler113312653wangler
wrangler1245473wrangler
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

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.436409841.7
2DLD Change Limit1340271797.39018136.3
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.88922650.7
 
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.