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

119 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
restrict1031363(None) 
restricts1138821restricts
abstrict1257942abstrict
astrict9614792_astrict
destruct1148382destruct
district11413872district
redistrict1355702redistrict
rescript1277422rescript
restraint9412752restraint
restricted1348302restricted
restrike1239672restrike
restring91518782restring
restrive11310922restrive
restruck1445222restruck
retract91318112re_tract
strict84821042__strict
abstract1249223abstract
abstricts1355183abstricts
astricts1049463_astricts
bestrid1039973bestri_d
bestride1138613bestride
centric11312403centric_
centrist10314863centrist
constrict13711623constrict
destrier9311823destrier
destructs1245773destructs
detract101414633de_tract
distract11313023distract
districts1248933districts
esprit8312843_espri_t
estreat7314813_estreat
estrin6315923_estri_n
estrins7315853_estrins
estriol747553_estriol
extract16311013_extract
gastric1038633gastric_
gentrice1148813gentrice
gestic9312773gest_ic_
instruct1047543instruct
metric10314673me_tric_
metrics11312363me_trics
metrist9317063me_trist
obstruct1246033obstruct
oestrin7312243oestri_n
oestrins8312673oestrins
oestriol845383oestriol
ostrich1238663_ostrich
postriot10412253postriot
prescript1547033prescript
prestrike1547493prestrike
readdict1246153readdict
rectrices1338873rectrices
rectrix1645363rectri_x
redbrick1742653redbrick
redirect11147993redirect
redistricts1453663redistricts
reerect92915883re_erect
refract121311603re_fract
reindict1187533reindict
relict83623903re__lict
reprice113212833re_price
reprint9318983re_print
rescripts1374573rescripts
resect84424703res__ect
reselect1059943reselect
reservice1445273reservice
reservist1246293reservist
resift94017723res__ift
resist64524533res__ist
resit54241043res__i_t
resorcin1046823resorcin
resort65728623resor__t
respect11412033res_pect
resplice1237253resplice
resplit9310373respli_t
respring111614063respring
resprout1078783resprout
restack1339433rest_ack
restart7320033rest_art
resting85031183rest_ing
restitch1344693restitch
restive10315933rest_ive
restock1338673rest_ock
restoring10314613restoring
restrain8311703restrain
restrains9311623restrains
restraints1056603restraints
restress82511773restress
restretch1473873restretch
restricken1643793restricken
restricting1449303restricting
restriction1349363restriction
restrictive1646363restrictive
restrikes1339413restrikes
restrings10159293restrings
restriven1246233restriven
restrives12310663restrives
restroom1047573restroom
restrove1138963restrove
restrung9176443restrung
resurrect1144883resurrect
retint65633443re_t_int
retrace91417343re_trace
retrack131310723re_track
retracts101111313re_tracts
retreat7317533re_treat
retrial7615553re_trial
retried84419153re_tried
retries74129073re_tries
retrim83514883re_tri_m
retrims93612373re_trims
retroact10410003re_troact
retrodict1247503re_trodict
retwist1039483re_twist
rustic8712673rust_ic_
rustics9810733rust_ics
strick124813203__strick
stript85222193__stript
vestries11314053vestries

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621197.33019940.2
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.81322871.0
 
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.