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

110 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
zonulae164596(None) 
zonula1537221zonula_
zonular1656491zonular
zonulas1637021zonulas
zonule1577481zonul_e
canulae9311182canulae
copulae112810612copulae
lunulae735612lunulae
morulae958962morulae
torulae758552torulae
zonae145116442zon__ae
zonules1647792zonules
alulae6312743_alulae
annular737693annular
annulate8310923annulate
boule74828043bo_ul_e
boulle84614613bo_ulle
cannulae1046493cannulae
canula8312963canula_
canular9310323canular
canulas9312853canulas
canulate10314553canulate
conchae143911643conchae
conclave1556403conclave
conflate13311173conflate
consular1038813consular
consulate11612233consulate
convulse1345443convulse
copula102812043copula_
copular113810603copular
copulas113811563copulas
copulate122614113copulate
coulee8323513co_ulee
cupulae11347853cupulae
dongle83612493dongl_e
doula65717773do_ula_
doulas75114993do_ulas
faculae123210353faculae
feculae12339203feculae
ferulae10309603ferulae
fibulae12237013fibulae
fondle104412943fondl_e
formulae1345983formulae
hondle103914523hondl_e
inulase739413_inulase
jocular1637303jocular
joule124918203jo_ul_e
ligulae8308753ligulae
lingulae9357033lingulae
lobular936663lobular
lobulate1078833lobulate
lobule82910063lobul_e
locular938953locular
loculate101011403loculate
locule83412033locul_e
lunula636173lunula_
lunular736013lunular
lunulate838253lunulate
lunule638433lunul_e
maculae113412863maculae
modular1087363modular
modulate1138593modulate
module93011033modul_e
morula8710473morula_
morular978223morular
morulas959713morulas
moulage1037903mo_ulage
nebulae955493nebulae
nodular876703nodular
nodule7309803nodul_e
nonglare946373nonglare
nonplay1246683nonplay
nonuple946153nonuple
nonuse63212253nonu_se
ocular8610133_ocular
onlay84212943_on_lay
ovular946833_ovular
ovulate1039453_ovulate
ovule839493_ovul_e
papulae11249353papulae
pinnulae1044183pinnulae
planulae1044793planulae
populace14256253populace
popular11319563popular
populate122812093populate
radulae837963radulae
ranula6311813ranula_
ranular739433ranular
ranulas7311773ranulas
rosulate8310903rosulate
roulade857003ro_ulade
scopulae1254613scopulae
spinulae10276963spinulae
synurae1044253synurae
torula6610393torula_
torulas759853torulas
ungulae837313ungulae
uvulae945323_uvulae
venular1037683venular
venule94411763venul_e
zoeae144412483zo__eae
zona136321963zon__a_
zonal145116853zon__al
zonally1938003zonally
zonate154114923zon_ate
zone135231083zon___e
zooglea1733373zooglea
zoogleae1842783zoogleae
zorille1636673zorille
zouave1833573zo_uave

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271105.78023188.1
3Display Results1101100.0502200.0
 (SQL Overall)1786911106.25028590.6
 
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.