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

173 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
shrivels1437644(None) 
shrivel13479401shrivel_
shrivers14419101shrivers
shrives134416171shrive_s
drivels11397922_drivels
scrives124414272scrive_s
shiels95418922sh_i_els
shivers133714832sh_ivers
shives124921412sh_ive_s
shovels13378392sh_ovels
shrieks14377672shri_eks
shrieves14297092shrieves
shrikes144412392shrike_s
shrills10389932shri_lls
shrines104618692shrine_s
shrive125216952shrive__
shrived144712182shrive_d
shriveled1643152shriveled
shriven13379652shrive_n
shriver134712192shrive_r
snivels10336902s_nivels
strivers113911842strivers
strives104119372strive_s
swivels13396772s_wivels
thrivers14456822thrivers
thrives134611712thrive_s
ariels65119373_ari_els
arrivals1145943arrivals
arrivers11137003arrivers
arrives101311513arrive_s
bedrivels1542713bedrivels
caravels1337443caravels
carvels124914593car_vels
chiels115115933ch_i_els
chisels12219103ch_isels
chives144317593ch_ive_s
derivers123811363derivers
derives114017813derive_s
drivel105110383_drivel_
drivers114412793_drivers
drives105117113_drive_s
frivols1334743_frivols
gravels113611143_gravels
grivets11357973_grivets
grovels11427813_grovels
hirsels10128353_hirsels
hives116925513_h_ive_s
hovels125413343_h_ovels
marvels123810093mar_vels
oriels64914623_ori_els
privets122910053_privets
ravels94717073__ravels
revels94220573__revels
riels55121333__ri_els
rivals94213183__rivals
rivers94626543__rivers
rives85336003__rive_s
rivets94417113__rivets
samiels939763sami_els
scribers12307963scribers
scribes113713203scribe_s
scries85226823scri_e_s
scrieves13387613scrieves
scrive115414943scrive__
scrived134511113scrive_d
seidels838393s_eidels
serials73919753seri_als
series64540973seri_e_s
serines74229543serine_s
servals103410753ser_vals
servers103214833ser_vers
serves94423653ser_ve_s
shavers134115093sh_avers
shaves125224933sh_ave_s
shavies134213213shavie_s
sheaves134412973sheave_s
sheeves133911953sheeve_s
shekels1436043sh_ekels
shelvers14388813shelvers
shelves134112093shelve_s
sheqels1934753sh_eqels
shiel811023773sh_i_el_
shield106212973sh_i_eld
shields11538043sh_i_elds
shiers94921753sh_i_ers
shies86136553sh_i_e_s
shills94519613sh_i_lls
shiners104015943sh_iners
shines95028913sh_ine_s
shires95225573sh_ire_s
shirkers15319583shirkers
shivahs16375723sh_ivahs
shivas124512413sh_iv_as
shive114423423sh_ive__
shiver124517373sh_ive_r
shivery16317023sh_ivery
shivs115018803sh_iv__s
shovel124611323sh_ovel_
shovers134613003sh_overs
shoves124919423sh_ove_s
shreds105613053shr__eds
shrews129313923shr__ews
shriek134211103shri_e_k
shriekers16224423shriekers
shrieky17364803shri_eky
shrieval1443363shrieval
shrieve13417683shri_eve
shrieved15276073shrieved
shrifts1335963shri_fts
shrike134513243shrike__
shrill94712303shri__ll
shrilled1246863shrilled
shriller1136823shriller
shrillest1245393shrillest
shrilly13318563shri_lly
shrimpers1633813shrimpers
shrimps14516753shri_mps
shrine94920053shrine__
shrined114112413shrine_d
shrinkers16205383shrinkers
shrinks14397913shri_nks
shris84221453shri___s
shriveling1743253shriveling
shrivelled1742373shrivelled
shriving15268453shriving
shrove125412233shrove__
shtetels1143233shtetels
sivers95324153s__ivers
skivers14409703s_kivers
skives134113943s_kive_s
slivers104115253s_livers
snivel9368853s_nivel_
sorels63921163sor__els
sorites73825243sorite_s
sorrels7310723sor_rels
spiels85317953s_pi_els
spinels94512443s_pinels
sprites94220333sprite_s
stipels9418953s_tipels
stivers103613543s_tivers
streels73811343str_eels
striders94412123striders
strides84520393stride_s
strifes104716583strife_s
strigils946853strigils
strikers123611293strikers
strikes114719093strike_s
stripers103911593stripers
stripes95320573stripe_s
strive95020963strive__
strived114713663strive_d
striven103910753strive_n
striver104315203strive_r
strudels934123strudels
stuivers11406673stuivers
surveils1144523sur_veils
surveys13357573sur_veys
survivals1543013survivals
survivers1543883survivers
survives1436333survive_s
swivel12369323s_wivel_
swives123915183s_wive_s
swivets13436963s_wivets
thraves13469713thrave_s
thrills10398783thri_lls
thrive125313223thrive__
thrived14458183thrive_d
thriven13447023thrive_n
thriver13479123thrive_r
travels104711293_travels
trivets103911583_trivets
unravels1144633unravels
uprivers13215563uprivers

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.423422437.4
2DLD Change Limit1461621736.42022766.7
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.90625874.7
 
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.