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

73 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
students95468(None) 
student848341student_
stents65019452st__ents
stunts65615252stu__nts
audients946353_audients
dents65031803___dents
eluents738703elu_ents
esculents1144693esculents
etudes73811603etude__s
hutments1345603hutments
indents83114663_indents
loudens8368053louden_s
mordents1138813mordents
nonstudents1252913nonstudents
obtundents13111703obtundents
pendents1139413pendents
prudent10310433prudent_
rodents8611543_rodents
saddens9309603sadden_s
salients839563salients
sapients1037423sapients
sarments10311963sarments
saturants946383saturants
scents85317023s__cents
segments1138903segments
sequents1756993sequents
serpents102410373serpents
shunts95712023shu__nts
silents73514493s_ilents
sklents11348163s_klents
soddens9348413sodden_s
solvents1136763solvents
sorbents10279133sorbents
soudans8309353soudan_s
splents93912133s_plents
squints16339033squ_ints
stades74626243stade__s
stamens93411483stamen_s
starets73515923stare_ts
stenos63915773st__enos
stent55634513st__ent_
stets55423913st__e_ts
stints65119763st__ints
stipends11304793stipends
stoutens8255273stouten_s
streets73312613st_reets
strident9310173strident_
strudels934123strude_ls
strunts7429543st_runts
studdies10207073studdies
studdings1242933studdings
studentship1761643studentship
studiers9236623studiers
studies82413863stud_ies
studios8256643stud_ios
studious9245553studious
studs64415873stud___s
stunners8277923stunners
stuns54719493stu__n_s
stunt55328173stu__nt_
stupes84116953stupe__s
sturts63915143stu__rts
stylets10369213style_ts
styrenes11116623styrenes
subnets92512083s_ubnets
subrents10310293subrents
suddens9308783sudden_s
suets55126103s_u_e_ts
suints64617783s_u_ints
syndets1136113synde_ts
talents7312013_talents
tents56434213_t__ents
tridents938583tridents

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162737.28320068.9
3Display Results73730.0302433.3
 (SQL Overall)178691737.48323879.6
 
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.