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

101 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
restricts113882(None) 
restrict10313631restrict_
abstricts1355182abstricts
astricts1049462_astricts
destructs1245772destructs
districts1248932districts
rectrices1338872rectrices
redistricts1453662redistricts
rescripts1374572rescripts
restraints1056602restraints
restricted1348302restricted
restrikes1339412restrikes
restrings10159292restrings
restrives12310662restrives
retracts101111312re_tracts
abstracts1346593abstracts
abstrict1257943abstrict_
astrict9614793_astrict_
bestrides1237913bestrides
centrists11410233centrists
constricts1477733constricts
destriers1038143destriers
destruct1148383destruct_
detracts11138833de_tracts
distracts1249283distracts
district11413873district_
esprits938393_espri_ts
estreats839423_estreats
estrins7315853_estri_ns
estriols856253_estriols
extracts1747623_extracts
gentrices1258913gentrices
instructs1145793instructs
metrics11312363me_tric_s
metrists1039853me_trists
obstructs1344573obstructs
oestrins8312673oestri_ns
oestriols944333oestriols
prescripts1644743prescripts
readdicts1343613readdicts
redbricks1842303redbricks
redirects12125103redirects
redistrict1355703redistrict_
reerects10319923re_erects
refracts13137383re_fracts
reindicts1274763reindicts
relicts94414593re__licts
reprices122913353re_prices
reprints1039903re_prints
rescript1277423rescript_
resects94115593res__ects
reselects1156413reselects
reservices1544893reservices
reservists1343923reservists
resifts10378703res__ifts
resists74414923res__ists
resits64725563res__i_ts
resorcins1146983resorcins
resorts74817193resor__ts
respects1247703res_pects
resplices1336623resplices
resplits1037723respli_ts
resprings12156253resprings
resprouts1174823resprouts
restacks1438093rest_acks
restarts8310873rest_arts
restitch1344693rest_itch
restocks1437503rest_ocks
restrains9311623restrains
restraint9412753restraint_
restress82511773restr_ess
restretch1473873restretch
restricken1643793restricken
restricting1449303restricting
restriction1349363restriction
restrictions1449283restrictions
restrictive1646363restrictive
restrictives1755083restrictives
restrike1239673restri_ke
restring91518783restri_ng
restrive11310923restri_ve
restriven1246233restriven
restrooms1146033restrooms
restruck1445223restruc_k
resurrects1242823resurrects
retints74717013re_t_ints
retraces101417273re_traces
retracks14149103re_tracks
retract91318113re_tract_
retreats8311413re_treats
retrials8510823re_trials
retries74129073re_tri_es
retrims93612373re_tri_ms
retroacts1146283re_troacts
retrodicts1344483re_trodicts
retwists1135603re_twists
rustics9810733rust_ic_s
stricks134310693__stricks
strict84821043__strict_
tectrices1346253tectrices
vestries11314053vestri_es

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411017.53319732.0
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.71923149.5
 
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.