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

95 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
springal114597(None) 
springald1343681springald
springals1245371springals
seringa83310742seringa_
seringas9339002seringas
spinal84915312sp_in_al
spring94526012spring__
springalds1442712springalds
springe103913982spring_e
springed123911322springed
springer113311752springer
springes114014032springes
springily1545582springily
springs104415922spring_s
springtail13132332springtail
springy13359662spring_y
syringa11366352syringa_
syringas12285952syringas
syringeal1343002syringeal
carinal94318243carin_al
gingal81010153__gingal
gringa838553_gringa_
gringas938043_gringas
jingal1498593__jingal
laryngal1242763laryngal
martingal1244063martingal
perineal1049203perineal
pineal84817693_p_ineal
pinnal84814283_p_innal
primal104014623_pri_mal
scribal1137963scri_bal
seminal91213413semin_al
serial64625863seri__al
sering74731813sering__
shrieval1443363shrieval
signal73711483s__ignal
siring75128313siring__
soring74731883soring__
sorings83817253soring_s
sparing104823873sparing__
sparingly1537283sparingly
sphinges14267483sphinges
sphingid1543743sphingid
spiegel1034553sp_iegel
spinage10289653sp_inage
spinals93911863sp_in_als
spinel85317333sp_in_el
spinula9257903sp_inula
spiral83715343sp_i_ral
spiring103918183spiring__
spiritual1144253spiritual
spital83813873sp_i_tal
splenial1047183splenial
sponsal946343sp_onsal
sporangial1353093sporangial
sporing104319413sporing__
sprang95713523sprang__
sprangs104610053sprang_s
sprig85617743spri_g__
sprigged13316223sprigged
sprigger12366503sprigger
spriggy14374213spri_ggy
spright132010403spri_ght
sprigs94814773spri_g_s
sprigtail12122773sprigtail
springbok1842003springbok
springers12309983springers
springhead17102693springhead
springier1236023springier
springing1338743springing
springlet1257523springlet
springtails14112223springtails
sprinkle1434893sprinkle
sprint84526793sprin__t
sprinted113411163sprinted
sprinter103810813sprinter
sprints94113773sprin_ts
spritsail1142183spritsail
sprung94610033sprung__
spuing94313363spuing__
spying123913253spying__
strigil837263stri_gil
string75327563string__
stringed102911873stringed
stringer93812943stringer
stringhalt1453953stringhalt
stringily1346003stringily
strings84617133string_s
stringy114111073string_y
strongyl1243553strongyl
syringe11349473syring_e
syringed13377583syringed
syringes122810213syringes
trinal6516963_trin_al
urinal6614123_urin_al

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.423422437.4
2DLD Change Limit146162957.53019410.6
3Display Results95950.0303166.7
 (SQL Overall)178691957.98322383.9
 
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.