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

84 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
restrained114841(None) 
restrainer1046971restrainer
retrained10411311re_trained
destained1158252dest_ained
detrained1158912de_trained
distrained1257672distrained
entrained1089412_entrained
mistrained1347582mistrained
pretrained1357062pre_trained
reattained1144582reattained
refrained1347222re_frained
restrain8311702restrain__
restrainedly1651792restrainedly
restrainers1145122restrainers
restrains9311622restrain_s
restraint9412752restrain_t
restraints1056602restraints
retained93016092re_t_ained
retrainee9511162re_trainee
strained9412252__strained
unrestrained1353282unrestrained
unstrained1146372unstrained
abstained1245053abst_ained
constrained1445353constrained
destined103312453dest__ined
detained103111643de_t_ained
distained1139603dist_ained
distrainer1146433distrainer
engrained1145493_engrained
entrainer968583_entrainer
estranged11387663_estranged
estrayed1236393_estra_yed
overstrained1645273overstrained
overtrained1547103overtrained
pertained1238503pert_ained
refrainer1245843re_frainer
regained102111243re__gained
remained112412893re__mained
reobtained1343393reobtained
reordained1243443reordained
reraised9312353re__raised
resailed93613063res__ailed
rescreened1344123rescreened
reserpine1147523reserpine_
reserpines1245843reserpines
reserviced1643753reserviced
reshined123011123res__hined
resined84522653res___ined
resprayed1544353respra_yed
restabled12148953rest_abled
restacked1636483rest_acked
restaffed1653753rest_affed
restaged103011863rest_a_ged
restamped1444433rest_amped
restarted10410053rest_arted
restated93120183rest_a_ted
restationed1244373restationed
restraining1247533restraining
restressed1146643restressed
restricted1348303restricted
restrike1239673restr_ike_
restrikes1339413restr_ikes
restring91518783restr_in_g
restrings10159293restr_ings
restrive11310923restr_ive_
restriven1246233restr_iven
restrives12310663restr_ives
restudied11104853restudi_ed
retailed94113963re_t_ailed
retainer82913813re_t_ainer
retraced111413023re_tra_ced
retracked1657453re_tracked
retracted12410953re_tracted
retrain7615423re_train__
retrainees1046393re_trainees
retrains8314533re_train_s
retried84419153re_tr_i_ed
sprained1138433__sprained
stained84215343__st_ained
strainer8512223__strainer
sustained1045383sust_ained
trained84117203___trained
unstained1038683unst_ained
untrained10510993_untrained

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603846.04623255.5
3Display Results84840.0461826.1
 (SQL Overall)178691846.49827499.4
 
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.