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 “spatulas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
spatulas104547(None) 
spatula935891spatula_
spatular1044651spatular
scapulas1246132scapulas
spatulate11107172spatulate
spatzles1935302spatzles
spirulas10207202spirulas
atlas55821583__at_las
blastulas1143593blastulas
canulas9312853_canulas
daturas838783_daturas
fistulas1155403fistulas
maculas113114023_maculas
pabular11259473_pabular
paellas9411413_paellas
papula103011113_papula_
papulae11249353_papulae
papular11299763_papular
papules112411573_papules
paruras9310533_paruras
patacas11311003_patacas
patellas1039103_patellas
patinas96318523_patinas
patulous10116363_patulous
payolas12148973_payolas
radulas839583_radulas
ranulas7311773_ranulas
sataras7315063s_ataras
satsumas1043573s_atsumas
sauls55128123s_a_ul_s
saults65816173s_a_ults
saunas63915433s_a_unas
saxtubas1741913saxtubas
scapula1136343scapula_
scapulae1255433scapulae
scapular1245373scapular
scapulars1343873scapulars
scopulas1265483scopulas
seagulls943743seagulls
shauls94913113sha_ul_s
skatoles1236143skatoles
skatols1135533skatol_s
spackles16319953spackles
spaetzles2042153spaetzles
spails84817823spa_il_s
spales84728103spa__les
spalls84217343spa__lls
spangles1138893spangles
spansules1143613spansules
sparkles143210493sparkles
spartinas1135793spartinas
spates85028173spat__es
spathal1236263spat_hal
spathes125116533spat_hes
spathulate1553163spathulate
spatial9310323spat_ial
spats75031383spat___s
spatters103914703spatters
spatzle1834583spatzl_e
specula11187413specula_
specular12217613specular
spicula11259293spicula_
spiculae12218603spiculae
spicular12238903spicular
spicules12219803spicules
spinula9257903spinula_
spinulae10276963spinulae
spinules10249333spinules
spirula9257703spirula_
spirulae10216573spirulae
spitals93011593spital_s
spittles1038333spittles
sporular1065223sporular
sporules1037703sporules
sprattles1174883sprattles
statues74614903statu_es
statures83711113statures
status65515213statu__s
statuses8409543statuses
statutes8368893statutes
stulls63912983s__tulls
stupas83910883s__tupas

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 Filter1786911461620.423422437.4
2DLD Change Limit146162826.57622226.6
3Display Results82820.0332484.8
 (SQL Overall)178691827.03225411.1
 
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.