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

90 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
spiracle125580(None) 
spiracles1345661spiracles
miracle1138842_miracle
sparable121611982sparable
spiral83715342spira_l_
spiraled1137732spira_led
spiralled1244402spiralled
spirally1348022spirally
spirals93212512spira_ls
aspiratae1143353aspiratae
aspirate1039943aspira_te
circle1039703_cir_cle
coracle112011723_coracle
epicycle1743393epicycle
hirable121612313_hirable
miracles1238333_miracles
operable12410323operable
oracle84313293__oracle
parable111819783_parable
percale11314093_percale
pinnacle12416963_pinnacle
pinocle1138143_pinocle
piracies12312643_piracies
piracy1339473_pirac_y
pirate82322883_pira_te
respirable1446023respirable
sailable10310563sailable
seisable10311373seisable
seizable1938723seizable
separable1348673separable
sharable131910693sharable
silicle937753s_ilicle
sizable1839893s_izable
skiable1338883ski_able
slidable1137953slidable
space95325673sp__ac_e
spackle15369573sp__ackle
spale74929213sp__a_le
sparables13167173sparables
spareable1337263spareable
sparkle133710213spar_kle
spectacle1544083spectacle
spicae104313703spi__cae
spicate113214193spica_te
spice95528813spi__c_e
spicule11269933spi_cule
spile75230083spi___le
spillable1345353spillable
spinach1435403spinac_h
spinaches1645273spinaches
spinachy1842793spinachy
spinage10289653spina_ge
spinal84915313spina_l_
spinally1338023spinally
spinals93911863spina_ls
spinate93114813spina_te
spindle103210093spi_ndle
spinelle1046223spinelle
spinule9299993spi_nule
spiracular1453593spiracular
spiraea9407983spira_ea
spiraeas10286233spiraeas
spirant9814293spira_nt
spirants1088283spirants
spire75828693spir___e
spireme11478363spir_eme
spirilla1045073spirilla
spirula9257703spir_ula
spirulae10216573spirulae
spital83813873spita_l_
spitals93011593spita_ls
spittle937923spi_ttle
spoilable1345163spoilable
sporal82915453spora_l_
sporule937273spor_ule
spraddle12194163sp_raddle
sprattle1054763sp_rattle
sprawl11188063sp_rawl_
sprawled1434523sp_rawled
sprawler1334653sp_rawler
sprawls12176373sp_rawls
sprawly15166043sp_rawly
sprinkle1434893sprinkle
spruce103910873sp_ruc_e
spurtle937453spur_tle
storable10310733storable
subrace11313003subrac_e
suitable10310893suitable
superable13312483superable
wirable121610963_wirable

Search took 9 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.826216332.9
2DLD Change Limit146162907.84318636.0
3Display Results90900.0461956.5
 (SQL Overall)178691908.71520503.8
 
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.