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

86 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
resecure104718(None) 
resecured1245531resecured
resecures1146731resecures
insecure1044652insecure
rescore95616202res_core
rescue8313002res_cu_e
rescuer939032res_cuer
reseizure18112832reseizure
secure8513532__secure
epicure1136823_epicure
execute1636783_execute
fescue1137493fes_cu_e
gesture839243ges_ture
nonsecure1145243nonsecure
obscure1145333obs_cure
pedicure1345183pedicure
persecute1344883persecute
precure11312553_precure
prefecture1744803prefecture
prescore124812373pres_core
pressure1039773pres_sure
prosecute1345953prosecute
rasure6311423ras__ure
reaccuse1245043reaccuse
reassure847343reassure
recur74116843r__ecur_
recurs83315803r__ecurs
recurve1237403r__ecurve
recuse85519163r__ecuse
redecide12127183redecide
reexecute1862723reexecute
refigure1254693refigure
reincur945133reincur_
reincurs1045553reincurs
reinjure1544983reinjure
reinsure837913reinsure
rejectee17289623rejectee
rejecter17258943rejecter
remeasure1143943remeasure
renature839323renature
reoccur1143353reoccur_
reoccurs1242963reoccurs
rerecord1145373rerecord
resalute857413resalute
rescale93215473res_cale
rescored114513103res_cored
rescores105415693res_cores
rescued10410043res_cued
rescuers1037363res_cuers
rescues9312753res_cues
reseau64216213reseau__
reseaus74012153reseau_s
reseaux14326233reseau_x
resect84424703resec__t
resected112514743resected
resects94115593resec_ts
resecuring1345123resecuring
resee54336333rese___e
reseize1639553rese_ize
reseizures19142583reseizures
reseller83412223reseller
resemble1247313resemble
reserve101011203rese_rve
reserver11119633reserver
resetter81511833resetter
resettle837303resettle
residue8689863residu_e
resolute868513resolute
resource1046313res_ource
respecter1347443respecter
respire9411543res_pire
restore75822983res_tore
resume8313783res__ume
resurge839073res__urge
retexture1643073retexture
reticule1049303reticule
revenue1039533revenu_e
revenuer1136893revenuer
revere94621253reve__re
secured1059723__secured
securer958253__securer
secures9613163__secures
sinecure1044323sinecure
tressure846483tres_sure
unsecured1244903unsecured
vesture10310373ves_ture

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 Filter1786911461620.406440125.6
2DLD Change Limit146162866.54622328.4
3Display Results86860.0302866.7
 (SQL Overall)178691866.98225593.1
 
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.