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

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

108 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
strident931017(None) 
trident8314191_trident
rident7520192__rident
staidest939802staidest
stridden1044272stridden_
stride75420962stride__
stridence1245102stridence
stridency1543902stridency
stridently1454592stridently
strider84315722stride_r
striders94412122striders
strides84520392stride_s
striding102713602striding
stringent1049092stringent
striven103910752striven_
student848342st_udent
tridents938582_tridents
accident13148183accident
acridest1138143acridest
ardent73022613_ar_dent
aridest8316143_aridest
astride8311973astride__
astringent1145903astringent
credent10313973_credent
detriment1249693detriment
diriment11410743diriment
erodent8313823_erodent
esurient849293esuri_ent
evident1139993_evident
incident11410203incident
irridenta1063923irridenta
mordent10313993mor_dent
nutrient848353nutri_ent
nutriment1146503nutriment
occident13126293occident
orient6322533_ori_ent
prudent10310433_prudent
resident9313753resident
rodent7519243__rodent
salient7419763sali_ent
sapient9415333sapi_ent
sarment9318763sar_ment
scandent1148493scandent
sediment11411103sediment
serpent92916283ser_pent
shriven13379653shriven_
silent64125843s__ilent
snidest8310913s_nidest
solidest9310383solidest
sorbent92915243sor_bent
sprent84522383spr__ent
spriest92718643spri_est
sprint84526793spri__nt
staider83912613staide_r
stent55634513st___ent
sterilant947283sterilant
stint57037663st_i__nt
stipend10386553st_ipend
stolidest1046113stolidest
straiten838613straiten_
straitens946233straitens
straitest949173straitest
street64125773str__eet
strewment1445683strewment
striae65422273striae__
stricken1436893stricken_
strict84821043stri__ct
strictest1147293strictest
stridences1344733stridences
stridor8467393strid_or
stridors9367323stridors
strife95318363strife__
strifes104716583strife_s
strike105619733strike__
strikeout1344063strikeout
striker113714173strike_r
strikers123611293strikers
strikes114719093strike_s
striking133012233striking
string75327563stri__ng
stripe85822443stripe__
striped105214363stripe_d
striper94514793stripe_r
stripers103911593stripers
stripes95320573stripe_s
stripiest1138013stripiest
striping112612523striping
stript85222193stri__pt
strive95020963strive__
strived114713663strive_d
striver104315203strive_r
strivers113911843strivers
strives104119373strive_s
striving122611393striving
strode75215973strode__
strudel835783strude_l
strudels934123strudels
strunt64918913str__unt
students954683st_udents
stupidest1244143stupidest
sturdiest10207393sturdiest
tridental1046623_tridental
triene64316383_tri_ene
triens65417543_tri_ens
trijet133916553_trije_t
trisect939733_trisect
tritest7315273_tritest
trivet93721883_trive_t

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.406440125.6
2DLD Change Limit1461621087.48619524.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.93822510.8
 
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.