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

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
strang7571831(None) 
sprang95713521sprang
stang66424691st_ang
strand74514821strand
strange85416341strange
string75327561string
strong74914881strong
strung75213021strung
estrange9488892estrange
orang65119942_orang
ourang73311062ourang
outrang83813952outrang
parang93715512parang
prang84820322_prang
rang56939172__rang
sang55441242s__ang
saran53730312saran_
sarans64224432sarans
sarong73914872sarong
satang75711562satang
scrag85916172scra_g
sering74731812sering
shrank13359122shrank
siring75128312siring
slang66324022s_lang
soring74731882soring
spang84919732s_pang
sprag86418692spra_g
sprangs104610052sprangs
spring94526012spring
sprung94610032sprung
stag57332002st_a_g
staig65519642st_aig
stand65923282st_and
stane55933002st_ane
stangs75018172st_angs
stank95823302st_ank
staring84527052staring
sting65330242st_ing
storing83921122storing
strafe95215982strafe
strafing122111192strafing
strain64919572strain
strains74218152strains
strait64025892strait
strake104017392strake
strands83711952strands
stranger94715102stranger
stranges94516762stranges
strangle98411502strangle
strap77925262stra_p
straps87721782straps
strass67117222strass
strata63616282strata
strath93216372strath
strati63518902strati
straw813321292stra_w
strawing122411622strawing
straws98718672straws
strawy1210312822strawy
stray88525572stra_y
straying122912692straying
strays96417932strays
strings84617132strings
stringy114111072stringy
strunt64918912strunt
stung65417152st_ung
stying105414572stying
swang95519722s_wang
tang56138692_t_ang
trank96222422_trank
tranq145416892_tranq
trans54933042_trans
twang94511862_twang
wrang94716112_wrang

Search took 3 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 Filter178691825510.356501941.0
2DLD Change Limit82551752.51632810.4
3Display Results75750.0164687.5
 (SQL Overall)178691752.88861873.6
 
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.