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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
strangest10321084(None) 
stranges94516761stranges_
strongest10338291strongest
estranges10359982estranges_
straitest949172straitest
strange85416342strange__
strangely1345412strangely
stranger94715102strange_r
strangers104112162strangers
strangles103011552strangles_
strawiest1237212strawiest
stringent1049092stringent
stringiest11197592stringiest
arranges939413arranges_
astringent1145903astringent
astringes1038333astringes_
braggest1296533_braggest
crankest1438143_crankest
deranges1039973deranges_
estrange9488893estrange__
estranged11387663estrange_d
estranger10447843estrange_r
estrangers11376103estrangers
frankest1536963_frankest
grandest10311573_grandest
granges93516523_granges_
oranges84215333_oranges_
orangiest1038463_orangiest
outranges102510013outranges_
ranges73826923__ranges_
rangiest93115983__rangiest
rankest112713813__rankest
sagest74920263s__a_gest
sanest64426693s__an_est
savagest1245763sava_gest
scantest101710183s_cantest
scraggiest1444363scraggiest
scrawniest1543483scrawniest
serenest82717623seren_est
slangiest10129073s_langiest
sprangs104610053sprang_s_
springes114014033springes_
springiest13156673springiest
stablest103312943st_ablest
stages75629493st_a_ges_
staggiest11148253st_aggiest
stagiest91613403st_agiest
staidest939803st_aidest
stalest73720173st_a_lest
stances93715963st_ances_
stanchest14218213st_anchest
stanes64933403st_an_es_
stanged94113843st_ange_d
stangs75018163st_ang_s_
starkest1239723st_arkest
starriest9159763starriest
steadiest1038513steadiest
steamiest1138403steamiest
sternest8314433stern_est
stingiest10209773st_ingiest
stoniest8413543st_oniest
storages9311103stora_ges_
strafes104516003stra_fes_
straggles11328503straggles_
straggliest1343613straggliest
straight1249183straig_ht
straightest1564343straightest
straights1345813straights
strakes114218073stra_kes_
stranded102710813strande_d
strander97112063strande_r
stranders10389933stranders
strands83711953stran_ds_
strang75718313strang___
strangeness1246093strangeness
strangered1245413strangered
strangle98411503strang_le
strangled11268983strangled
strangler10369473strangler
stranglers11396823stranglers
strangury1343203strangury
strapless1135793strapless
strappiest1444373strappiest
strasses81311443strasses_
strategist1154773strategist
stravages1345843stravages_
streakiest1444763streakiest
streamiest1245113streamiest
strictest1147293strictest
stringed102911873stringe_d
stringer93812943stringe_r
stringers104210643stringers
stringless1145353stringless
strings84617133string_s_
stripiest1138013stripiest
stronger9349693stronge_r
strongish1344923strongish
swankest15105933s_wankest
syringes122810213syringes_
tangent8314993_t_angent
tangiest92915223_t_angiest
tannest72617853_t_annest
trances93919643_trances_
transect10410053_transect
transept1048633_transept
trapnest10310923_trapnest
triggest1036923_triggest
twangiest1355223_twangiest
wrongest1236733_wrongest

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.423422437.4
2DLD Change Limit1486411096.64022385.7
3Display Results1091090.0631730.2
 (SQL Overall)1786911097.12625075.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.