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

77 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
strategy124436(None) 
stately10310222st_ately
strategic1244042strategic
stratify1445702stratify
geostrategy1651233geostrategy
irately1047683_irately
lyrately1443163lyrately
scraggy14304583scra_ggy
scratchy1843653scratchy
sedately1245223sedately
seriately1246023seriately
slatey95417063s_late_y
stagey105915583st_age_y
staggy115510393st_a_ggy
stagy96618893st_a__gy
stalely1039213st_alely
started84217323starte_d
starter73817883starte_r
starters83714783starters
startsy10536703start_sy
state56237333st_ate__
stated75427833st_ate_d
statedly1245833st_atedly
stater64427563st_ate_r
staters73922343st_aters
states64337083st_ate_s
statusy10455423st_atusy
strafe95215983strafe__
strafed114413333strafe_d
strafer103912463strafe_r
strafers11379913strafers
strafes104516003strafe_s
straggly13355563straggly
straiten838613straite_n
straitens946243straitens
straiter8311783straite_r
straitest949173straitest
straitly1136563straitly
strake104017393strake__
straked125415343strake_d
strakes114218073strake_s
stramony1344933stramony
strang75718313stra_ng_
strange85416343stra_nge
strangely1345413strangely
stranger94715103stranger
stranges94516763stranges
strappy14205263stra_ppy
strata63616283strat__a
stratagem1263933stratagem
stratal72710603strat_al
stratas73013583strat_as
strategies1155603strategies
strategist1154783strategist
strategize2053183strategize
strath93216373strat__h
straths102711723strat_hs
strati63518903strat__i
stratous8410703stratous
stratum9318253strat_um
stratums10266813stratums
stratus73011733strat_us
stravage1245563stravage
strawed114813623strawe_d
strawy1210312823stra__wy
stray88525573stra___y
strayed114513283straye_d
strayer104312503straye_r
strayers113510143strayers
stretchy1644083stretchy
striate74218953striate__
striated93414153striate_d
striates83417083striate_s
stringy114111073str_ingy
tracery12399793_tracery
tragedy1234793_tragedy
tritely1039003_tritely

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 Limit146162777.57619292.8
3Display Results77770.0332333.3
 (SQL Overall)178691778.03222247.4
 
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.