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

62 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
restudies1015603(None) 
restudied11104851restudied
studies82413862__studies
testudines1143092testudines
besmudges1542413besmudges
bestrides1237913bestrides
bestudded1442533bestudded
bestuds10326753bestud__s
centuries11311333centuries
cestodes1138203cestod_es
cestuses1038083cestu_ses
custodies1245963custodies
destinies10410843destinies
estuaries946213_estuaries
etudes73811603_e_tud_es
gestures9310013gestu_res
outstudies1142663outstudies
overstudies1574043overstudies
readies83324713re__adies
rebodies1139163re_bodies
reburies10311143re_buries
rectifies14310813rectifies
rectories11314643rectories
rejudges1734153re_judges
remedies11310553re_medies
resaddles11114693resaddles
rescues9312753rescu__es
resides84523283res_id_es
residues9338813res_idues
resituates1047753resituates
resources1146203resources
respades1139853respad_es
restables111511423restables
restages92815773rest_ages
restates83423433rest_ates
restokes125213043rest_okes
restores85222993rest_ores
restrains9311623restrains
restrikes1339413restrikes
restrives12310663restrives
restudy1144763restud__y
restudying1543423restudying
restuffed1663333restuffed
restuffs1444193restu_ffs
restyles1139193rest_yles
resumes9313373res_u_mes
resurges9310123res_urges
reties65436193re_t__ies
retries74129073re_t_ries
retunes76918403re_tu_nes
studdies10207073__studdies
studied9268693__studied
studier82510053__studier
studiers9236623__studiers
studios8256643__studios
sturdies92110273__sturdies
testacies1148373testacies
testifies12139263testifies
testudos943053testud_os
unstudied1194283unstudied
vestries11314053vest_ries
vestures11311043vestu_res

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.423422437.4
2DLD Change Limit148641626.81321817.3
3Display Results62620.0134769.2
 (SQL Overall)178691627.24924650.4
 
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.