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

47 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
upsprings144270(None) 
upspring1335701upspring_
outsprings1343952outsprings
resprings12156252resprings
springs104415922__springs
unstrings1046012unstrings
uppings12257122up_p_ings
upsprang1342082upsprang_
upsprung1341702upsprung_
upswings1433002ups_wings
bedsprings1642353bedsprings
cuppings15336053cup_p_ings
daysprings1741573daysprings
lustrings10245553lustrings
misprints13107223misprints
offsprings1951313offsprings
outspring1238903outspring_
outsprints1243573outsprints
pairings11398313_pairings
parings104219213_p_arings
pipings12338253_pip_ings
raspings11337853rasp_ings
respring111614063respring_
restrings10159293restrings
sorings83817253__sorings
speerings12276843speerings
sprangs104610053__sprangs
sprigs94814773__spri_gs
spring94526013__spring_
springe103913983__springe
springes114014033__springes
springy13359663__springy
sprints94113773__sprints
strings84617133__strings
unslings937283uns_lings
unsparing1237713unsparing_
unsprung1143173unsprung_
unstring9312093unstring_
upflings1433733up_flings
upping114013703up_p_ing_
uprisings1243343uprisings
upsizing2035413upsizing_
upsoaring1244513upsoaring_
upspringing1752093upspringing
upstaring1235963upstaring_
upsurging1343353upsurging_
upswing1335593ups_wing_

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 Filter1786911486410.423422437.4
2DLD Change Limit148641476.12324275.8
3Display Results47470.0162937.5
 (SQL Overall)178691476.56227231.2
 
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.