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

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

164 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
shiers9492175(None) 
sheers94322401sheers
shiels95418921shiels
shier85428941shier_
shies86136551shie_s
shiners104015941shiners
shires95225571shires
shirrs94413171shirrs
shivers133714831shivers
shoers94518331shoers
shyers124712201shyers
skiers104713701skiers
spiers84421741spiers
ashier94714832ashier_
ashlers10319582ashlers
biers76225222_biers
briers85319732briers
cahiers123510672cahiers
cashiers13318882cashiers
cheers114518912cheers
chiders135312942chiders
chiefs14509652chiefs
chiels115115932chiels
chimers144515142chimers
chirrs114514982chirrs
criers83918582criers
driers74516732driers
fliers94417192fliers
friers94718932friers
heirs85618562_heirs
hers75844872_h_ers
hiders104919652_hiders
hies74842832_hie_s
hikers135014352_hikers
hirers94518062_hirers
hires86134342_hires
hoers85724922_hoers
kiers95320092_kiers
liers55130402_liers
osiers63412792osiers
piers75926332_piers
pliers84715152pliers
priers84521192priers
sabers85224732sabers
sailers73822322sailers
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
seders74420282seders
seers55136382s_eers
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
sers45746652s__ers
severs94121122severs
sewers94719722sewers
shaders115915552shaders
shakers144015562shakers
shapers124016892shapers
sharers104720622sharers
shares95236412shares
shavers134115092shavers
shears93820902shears
sheas86331792sh_eas
sheds96122702sh_eds
sheens95116992sheens
sheer84726892sheer_
sheets93918502sheets
sheiks132510012sheiks
sherd96321152sh_erd
sherds105614722sh_erds
shes75734352sh_e_s
shewers134312052shewers
shews115924712sh_ews
shickers173012822shickers
shied96125492shie_d
shiel811023772shie_l
shield106212972shield
shields11538042shields
shiest95821522shiest
shifters14319862shifters
shifts124412942shifts
shikars1436182shikars
shikkers14326522shikkers
shills94519612shills
shimmers15269412shimmers
shims104422552shi_ms
shiner93820872shiner_
shines95028912shines
shins85131042shi_ns
shippers153012312shippers
ships105123772shi_ps
shire84727132shi_re
shirk124817842shi_rk
shirkers15319582shirkers
shirks134814122shirks
shirr84716922shi_rr
shirt84533902shi_rt
shirts94918342shirts
shists96515112shists
shits84731172shi_ts
shivas124512412shivas
shiver124517372shiver_
shivery16317022shivery
shives124921412shives
shivs115018802shi_vs
shleps114710332shleps
shmears1277072shmears
shoer84722162shoer_
shoes85429662shoe_s
shores94830412shores
shovers134613002shovers
showers134612682showers
shreds105613052shreds
shrews129313922shrews
shrieks14377672shrieks
shrivers14419102shrivers
shyer114714782shyer_
sieurs659042s_ieurs
sires55945372s_ires
sirs44338332s_i_rs
sivers95324152sivers
sizers155215812sizers
skier95119592skier_
skies95026832skie_s
skirrs10448192skirrs
skivers14409702skivers
slicers94114922slicers
sliders83515222sliders
slier54827242slier_
slivers104115252slivers
smilers94113852smilers
smiters93414362smiters
sneers64016172sneers
snipers93311772snipers
sobers85218862sobers
sowers94923442sowers
speers85019952speers
speirs85013232speirs
spicers113815552spicers
spiders103914412spiders
spiels85317952spiels
spier75728032spier_
spies76037622spie_s
spikers135311992spikers
spires84628112spires
steers63820982steers
sties55132982stie_s
stirs55921622sti_rs
stivers103613542stivers
subers85722642subers
suers55128482s_uers
suiters73618882suiters
supers84622402supers
theirs94610352theirs
tiers55526522_tiers
triers64321522triers
twiers95410162twiers
ushers94415532ush_ers
viers85621952_viers
whiners134011572whiners
whirrs12408592whirrs
whirs115218092whi_rs

Search took 3 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 Filter178691825510.403443402.0
2DLD Change Limit825511642.50033020.4
3Display Results1641640.0503280.0
 (SQL Overall)1786911642.95360511.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.