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

56 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
restraints105660(None) 
restrains9311621restrain_s
restraint9412751restraint_
distraints1166872distraints
restrain8311702restrain__
restrained1148412restrained
restrainer1046972restrainer
restrainers1145122restrainers
restricts1138822restr_icts
restrings10159292restr_ings
retrains8314532re_train_s
unrestraints1252072unrestraints
constraints1346203constraints
destains9311813dest_ain_s
detrains9411763de_train_s
distrains10411333distrain_s
distraint101112903distraint_
entrains8312963_entrain_s
entrants8311753_entra_nts
estrins7315853_estr_in_s
eyestrains1343563eyestrain_s
mistrains11511353mistrain_s
oestrins8312673oestr_in_s
pretrains11410143pre_train_s
reattains946443reattain_s
reentrants1044663reentra_nts
refrains1139593re_frain_s
registrants1253063registra_nts
regrants9310013re_gra_nts
repaints1038483re__paints
reprints1039903re_pr_ints
rescripts1374573rescr_ipts
reserpines1245843reserpines
reservists1343923reservists
resonants946693resona_nts
resorcins1146983resorcin_s
resprings12156253respr_ings
restarts8310873rest_a_rts
restaurants1152023restaura_nts
restraining1247533restraining
restrict10313633restr_ict_
restrikes1339413restr_ikes
restring91518783restr_in_g
restrives12310663restr_ives
retains74522253re_t_ain_s
retints74717013re_t__ints
retirants947323retira_nts
retracts101111313re_tra_cts
retrain7615423re_train__
retrained10411313re_trained
retrainee9511163re_trainee
retrainees1046393re_trainees
seatrains947603seatrain_s
strains74218153__strain_s
straits74916323__strai_ts
unrestraint1154273unrestraint_

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 Filter1786911406030.423422437.4
2DLD Change Limit140603566.95020230.6
3Display Results56560.0331697.0
 (SQL Overall)178691567.40624127.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.