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

75 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
spiralled124440(None) 
spiraled1137731spira_led
spalled103113132sp__alled
spilled103613622spi__lled
spiracle1255802spiracle_
spiracles1345662spiracles
spirally1348022spirall_y
sprawled1434522sp_rawled
spurgalled1441762spurgalled
appalled1344813ap_palled
aspirated1247703aspira_ted
corralled1245283corralled
dialled9510133_di_alled
muralled1136423_muralled
overalled1339073overalled
palled94625163_p__alled
parallel1047473_parallel
pedalled1246933_pedalled
perilled11410113_perilled
petalled1138713_petalled
pilled94222753_pi__lled
pinballed1444033_pinballed
pirated102515613_pira_ted
prilled104713003_p_rilled
rivalled1236093_rivalled
sandalled1145903sandalled
scrawled1445923s_crawled
scrolled1137063s_crolled
sepalled1156903s_epalled
shilled113313623shi__lled
shrilled1246863s_hrilled
signalled1143843signalled
skilled123110863ski__lled
skirled12348183skir__led
snivelled1353993snivelled
spaller92713473sp__aller
sparable121611983sparable_
sparables13167163sparables
sparkled15317733spar_kled
spelled103714743sp__elled
spicated13309903spica_ted
spieled104811883spi__eled
spiled94621993spi___led
spiller92914333spi__ller
spinally1338023spinall_y
spindled12287643spi_ndled
spinelle1046223spinelle_
spinelles1146083spinelles
spiraea9407983spira__ea
spiral83715343spira_l__
spiraling1237953spiraling
spirality1446433spirality
spiralling1343963spiralling
spirals93212513spira_l_s
spired94921863spir___ed
spirilla1045073spirill_a
spirillum1352643spirillum
spirited1148973spir_ited
spirted103913073spir__ted
spirulae10216573spirulae_
spraddled14203463sp_raddled
sprained1138433sp_rained
sprattled1263313sp_rattled
sprawler1334653sp_rawler
sprayed13398903sp_ra_yed
sprinkled1633713sprinkled
squalled1835943s_qualled
stalled83515693s__talled
stilled83314793sti__lled
strolled937823s_trolled
swilled113611833swi__lled
swirled11308223swir__led
swivelled1662963swivelled
thralled1245803_thralled
vialled1156843_vi_alled

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 Filter1786911486410.436409841.7
2DLD Change Limit148641757.22020587.4
3Display Results75750.0302500.0
 (SQL Overall)178691757.68623248.9
 
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.