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

32 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
overstrains144716(None) 
overstrain1347041overstrain_
overtrains13109501over_trains
overstrained1645272overstrained
overtrain1259782over_train_
eyestrains1343563eye_strains
oestrins8312673o_e_str_ins
overspins1439043overs__pins
overstaffs1943063overst_affs
overstates131110113overst_ates
overstating15410733overstating
overstaying1847053overstaying
overstays1535943overst_a_ys
overstirring1644533overstirring
overstirs1238213overst__irs
overstories1447143overstories
overstraining1754133overstraining
overstress1345763overstr_ess
overstrewing1944673overstrewing
overstrewn1643463overstrewn_
overstrews1644473overstr_ews
overstride1447073overstr_ide
overstrides1545873overstrides
overstriding1745613overstriding
overstrung1444373overstr_ung
overstudies1574043overstudies
overtrades1457493over_trades
overtrading1648263over_trading
overtrained1547103over_trained
overtrims1447503over_tr_ims
restrains9311623_re_strains
veratrins1247753_veratr_ins

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633325.14323650.2
3Display Results32320.0132461.5
 (SQL Overall)178691325.54632219.8
 
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.