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 “restructuring” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
restructuring167279(None) 
prestructuring1991851prestructuring
structuring1453172__structuring
destructing1546113destruct__ing
restricting1449303restrict__ing
restructure13195453restructur__e
restructured15164433restructur_ed
restructures14205303restructur_es
instructing1446294instruct__ing
obstructing1644574obstruct__ing
prestructure16174174prestructur__e
prestructured18173354prestructur_ed
prestructures17153844prestructur_es
resecuring1345124res__ec_uring
restituting12156564rest__ituting
restretching1852894restr_etching
retexturing1952464re_t_exturing
retracting13311934re_tract__ing
abstracting1645185abstract__ing
abstricting1654505abstrict__ing
astricting1357835_astrict__ing
bescouring1584645bes___couring
constructing1746755construct__ing
destituting13155165dest__ituting
destruction1446955destruct__ion
destructions1547255destruct_ions
destructive1755695destruct__ive
destructivity2262705destructivity
desulfuring1651935des__ulfuring
detracting1438715de_tract__ing
distracting1569255distract__ing
districting1559005district__ing
distrusting1386495distrust__ing
enrapturing1452345_e_nrapturing
entrusting11126185_entrust__ing
eructating1345695_e__ructating
eructing112110175_e__ruct__ing
estreating11710365_estreat__ing
extracting2047225_extract__ing
fracturing1643935___fracturing
gesturing1136655ges____turing
lecturing1237305le____cturing
menstruating1553865menstruat__ing
mistrusting1465925mistrust__ing
mistutoring1442825mist_u_toring
recapturing1643765re__capturing
reconstructing1974435reconstruct__ing
recruiting1347905re_cruit__ing
redirecting1545615redirect__ing
redistricting1753785redistrict__ing
reerecting1339975re_erect__ing
refracting1638735re_fract__ing
reinducting1544385reinduct__ing
reluctating1445765re__luctating
relucting1239775re__luct__ing
remanufacturing2371825remanufacturing
renaturing11176815re___naturing
rencountering16122475rencountering
resaluting1137395resalu_t__ing
rescoring12310605res___c_oring
rescuing1139625res___c_u_ing
resecting122816485res__ect__ing
reselecting1446025reselect__ing
resituating1247545resituat__ing
resorting10614615resor__t__ing
respecting1549885res_pect__ing
resprouting1445055respr__outing
restacking1737185rest_ac__king
restarting11310665rest_art__ing
restating102319415rest__at__ing
restitching1744005rest__itching
restocking1745705rest_oc__king
restoring10314615res____toring
restraining1247535restr__aining
restressing1266045restr__essing
restriction1349365restrict__ion
restrictions1449285restrict_ions
restrictive1646365restrict__ive
restriking1548045restr___iking
restring91518785res____t_ring
restringing1345715restr__inging
restriving1448135restr___iving
restrung9176445restr___u__ng
restudying1543425rest_u__dying
restuffing1743165rest_u__ffing
resulting10311085res__ult__ing
resurrecting1553125resurrect__ing
retouching1644695re_touc__hing
retracing12313295re_trac___ing
retracking1738165re_trac__king
retreating111414775re_treat__ing
retroacting1447285re_troact__ing
retroceding1544135re_troc_eding
retrofiring1544185re_tr_ofiring
reuttering1137575re___uttering
rupturing1244355____rupturing
structural1254395__structur_al
structure1145245__structur__e
structured1343995__structur_ed
structures1245455__structur_es
strunting1037875__strunt__ing
strutting1037005__stru_t_ting
stuttering1196355__st_uttering
suturing9310375__s__u_turing
tincturing1343325___tincturing
unstructured1553315unstructur_ed
vesturing1337205ves____turing

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901079.33013375.1
3Display Results1071070.0631698.4
 (SQL Overall)1786911079.78318265.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.