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

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

49 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
stranges9451676(None) 
estranges10359981estranges
strange85416341strange_
stranger94715101stranger
strangers104112161strangers
strangest103210841strangest
strangles103011551strangles
arranges939412arranges
astringes1038332astringes
deranges1039972deranges
estrange9488892estrange_
estranged11387662estranged
estranger10447842estranger
estrangers11376102estrangers
granges93516522_granges
oranges84215332_oranges
outranges102510012outranges
ranges73826922__ranges
sprangs104610052sprang_s
springes114014032springes
stages75629492st_a_ges
stances93715962st_ances
stanes64933402st_an_es
stanged94113842st_anged
stangs75018162st_ang_s
storages9311102stora_ges
strafes104516002stra_fes
straggles11328502straggles
strakes114218072stra_kes
stranded102710812stranded
strander97112062strander
stranders10389932stranders
strands83711952stran_ds
strang75718312strang__
strangely1345412strangely
strangle98411502strangle
strangled11268982strangled
strangler10369472strangler
stranglers11396822stranglers
strasses81311442strasses
stravages1345842stravages
stringed102911872stringed
stringer93812942stringer
stringers104210642stringers
strings84617132string_s
stronger9349692stronger
strongest10338292strongest
syringes122810212syringes
trances93919642_trances

Search took 4 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 Filter1786911210590.410435831.7
2DLD Change Limit121059493.51334460.3
3Display Results49490.0163062.5
 (SQL Overall)178691493.93945364.6
 
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.