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

196 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
shriller113682(None) 
shrilled1246861shrilled
thriller1165551thriller
chiller124112182ch_iller
driller84311882_driller
friller104111742_friller
griller84513352_griller
hiller94421632_h_iller
schiller13296472schiller
sheller103515882sh_eller
shilled113313622sh_illed
shrieker15265652shrieker
shrill94712302shrill__
shrillest1245392shrillest
shrills10389932shrill_s
shrilly13318552shrill_y
shrimper1544412shrimper
shrinker15236362shrinker
shriver134712192shri_ver
siller64026062s__iller
spiller92914332s_piller
stiller73414292s_tiller
stroller848172stroller
swiller103211662s_willer
thrilled1235492thrilled
thrillers1244472thrillers
triller74215892_triller
biller84923483__biller
brailler1036883brailler
bridler103811073_bridler
caroller1039203caroller
caviller1337063caviller
chilled133310933ch_illed
chillers133710923ch_illers
chillier13328423ch_illier
cruller968753_cruller
drilled94711673_drilled
drillers9429723_drillers
droller84110283_droller
enroller867183enroller
eviller1056673_eviller
filler94623623__filler
frilled113911603_frilled
frillers11349873_frillers
frillier1136513_frillier
giller74519733__giller
grille74315743_grille_
grilled94012833_grilled
grillers93810813_grillers
grillery12355503_grillery
grilles83715023_grilles
hailer94720343_hai_ler
heller93322513_h_eller
hilled104022223_h_illed
hillers103718733_h_illers
hillier103413963_h_illier
holler93520613_h_oller
huller93919103_h_uller
iller54821293___iller
killer104917953__killer
kruller1145153_kruller
miller84625413__miller
perilled11410093perilled
philter12108213ph_ilter
prilled104712993_prilled
reroller8258753reroller
rifler94014263__rifler
rille55728733__rille_
rilled74525653__rilled
rilles64725503__rilles
rillet64828853__rillet
roller63919793__roller
sailer63526103s_ai_ler
schillers14285663schillers
scrawler1345883scrawler
scribbler15164223scribbler
scriber113910963scri_ber
scrimper1455753scrimper
scripter12137773scripter
scrolled1137043scrolled
sculler99812153s_culler
seller63824593s__eller
shackler17317973shackler
shalier103116423sh_alier
shelled113815083sh_elled
shellers112812573sh_ellers
shellier1138393shellier
shelter103214953sh_elter
shelver134211063sh_elver
shicker163914823sh_icker
shielder1235183shielder
shier85428943sh_i__er
shifter132911073sh_ifter
shikker13277023sh_ikker
shill85325333sh_ill__
shills94519613sh_ill_s
shimmer143310873sh_immer
shiner93820873sh_i_ner
shingler12268633shingler
shinier104113143sh_inier
shipper143514043sh_ipper
shirker143711343sh_irker
shirtier1137933shirtier
shiver124517373sh_i_ver
shoaler102610073sh_oaler
shoalier1137063shoalier
shoulder1234753shoulder
shoveler14165583shoveler
shoveller15174543shoveller
shredder1334393shredder
shrewder1534393shrewder
shriek134211103shri__ek
shrieked16265173shrieked
shriekers16224423shriekers
shriekier1652963shriekier
shrieve13417683shrieve_
shrieved15276073shrieved
shrieves14297093shrieves
shrike134513243shri_ke_
shrikes144412393shri_kes
shrilling13307693shrilling
shrillness1343223shrillness
shrimped1634213shrimped
shrimpers1633813shrimpers
shrimpier1643063shrimpier
shrine94920053shri_ne_
shrined114112413shri_ned
shrines104618693shri_nes
shrinkers16205383shrinkers
shrive125216953shri_ve_
shrived144712183shri_ved
shrivel13479403shri_vel
shriveled1643153shriveled
shrivelled1742373shrivelled
shrivels14376443shrivels
shriven13379653shri_ven
shrivers14419103shri_vers
shrives134416173shri_ves
shuffler17306793shuffler
shuttler1164893shuttler
sidler74716963s__idler
sillers73822103s__illers
sillier74017593s__illier
silver93815813s__ilver
skilled123110863s_killed
skillet113512153s_killet
smaller93410333s_maller
smeller94212783s_meller
smiler83916683s_mi_ler
sneller73512843s_neller
spaller92713473s_paller
speller95415143s_peller
spieler93111233s_pieler
spilled103613623s_pilled
spillers103311703s_pillers
spoiler93310683spoi_ler
sprawler1334643sprawler
sprier84119063spri__er
sprigger12366493sprigger
springer113311753springer
sprinkler1543573sprinkler
sprinter103810813sprinter
spritzer1944553spritzer
squaller1736083squaller
stifler102911473s_tifler
stilled83314783s_tilled
stillier868823s_tillier
stricter1039423stricter
strider84315723stri_der
striker113714173stri_ker
stringer93812943stringer
striper94514793stri_per
stripier1058863stripier
stripper1247123stripper
striver104315203stri_ver
strolled937813strolled
strollers937543strollers
surlier72915443sur_lier
sweller103012463s_weller
swilled113611833s_willed
swillers11299113s_willers
swirlier1135213swirlier
thralled1245803thralled
thrill94910593thrill__
thrills10398783thrill_s
thriver13479123thri_ver
tiller64222543__tiller
trifler103912153_trifler
trilled84116313_trilled
trillers83613493_trillers
troller73913173_troller
whirler13307603wh_irler
whirlier14175293whirlier
willer94021063__willer
zorille1636673zorille_
zorilles1736123zorilles

Search took 9 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.1561145455.1
2DLD Change Limit1461621968.08018089.4
3Display Results1961960.0762578.9
 (SQL Overall)1786911968.31221498.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.