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

83 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
resecures114673(None) 
resecure1047181resecure_
resecured1245531resecured
rescores105415692res_cores
rescuers1037362res_cuers
rescues9312752res_cu_es
reseizures19142582reseizures
secures9613162__secures
epicures1246513_epicures
executes1736533_executes
fescues1236783fes_cu_es
gestures9310013ges_tures
insecure1044653insecure_
obscures1245513obs_cures
pedicures1445263pedicures
persecutes1444353persecutes
precures12312903_precures
prefectures1844303prefectures
prescores133912173pres_cores
pressures1149063pres_sures
prosecutes1445663prosecutes
rasures7312013ras__ures
reaccuses1345693reaccuses
reassures937223reassures
recurs83315803r__ecur_s
recurves1337403r__ecurves
recuses94619463r__ecuses
redecides1356563redecides
reechoes1338413re_echoes
reexecutes1962623reexecutes
refigures1344543refigures
refocuses14135953refocuses
reincurs1045553reincur_s
reinjures1645053reinjures
reinsures937963reinsures
rejectees18235423rejectees
rejecters18257543rejecters
remeasures1243853remeasures
renatures939443renatures
reoccurs1242963reoccur_s
rerecords1244003rerecords
resalutes947433resalutes
rescales103414573res_cales
rescore95616193res_core_
rescored114513103res_cored
rescue8313003res_cu_e_
rescued10410043res_cu_ed
rescuer939033res_cu_er
reseaus74012153reseau__s
resected112514743resec_ted
resects94115593resec__ts
resecuring1345123resecuring
resees63827483rese___es
reseizes1759853rese_izes
reseizure18112833reseizure_
resellers9299903resellers
resembles1376073resembles
reservers12138103reservers
reserves111011983rese_rves
resetters9129463resetters
resettles936563resettles
residues9338813residu_es
resolutes968193resolutes
resources1146203res_ources
respecters1445863respecters
respires10311903res_pires
restores85222993res_tores
resumes9313373res__umes
resurges9310123res__urges
retextures1743003retextures
reticules1139013reticules
revenuers1235983revenuers
revenues1138663revenu_es
reveres103621343reve__res
secure8513533__secure_
secured1059723__secured
securer958253__securer
securers1057153__securers
securest1058583__securest
sinecures1144543sinecures
tressures946293tres_sures
unsecured1244903unsecured
vestures11311043ves_tures

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 Limit148641837.59319576.1
3Display Results83830.0302766.7
 (SQL Overall)178691837.77922970.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.