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

306 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
sherifs1329968(None) 
serifs94017051s_erifs
sharifs13279901sharifs
sherif122915241sherif_
sheriff16287691sheriff
sheriffs17253921sheriffs
seifs85019332s_e_ifs
serfs84922012s_er_fs
series64540972s_eries
serif84132132s_erif_
serins64029672s_erins
sferics1236132sferics
sharias102516002sharias
sharif122917122sharif_
sheafs124912882she_afs
sheiks132510012she_iks
sherds105614722sher_ds
shereefs1433862shereefs
sherpas1238092sherpas
sherries111812892sherries
sherris10168802sherris
shrift12413542sh_rift
shrifts1335962sh_rifts
shris84221452sh_ri_s
spherics1537072spherics
aeries64737783_aeries
aerify122810113_aerify
aperies9423203aperies
asterias8317013asterias
cerias83321983_cerias
cheerios13317583cheerios
chefs136214663che__fs
chemics16349583chemics
cherish15310463cherish
cherries131812983cherries
cherts115617233cher_ts
cherubs1434553cherubs
chervils1644553chervils
chevies153511443chevies
clerics1149333clerics
clerids1049093clerids
disherits1348233disherits
emeries91620023emeries
esterify1445623esterify
etherify1744443etherify
faeries104118993faeries
ferias95020393_ferias
fisheries1548643fisheries
gherkins1643993gherkins
heils85222193_he_ils
heirs85618563_he_irs
helios94816633_helios
hemins113417563_hemins
henries102718283_henries
herbs105520503_her_bs
herdics13249523_herdics
herds96424683_her_ds
heres86245903_her_es
heriot9422343_heriot
heriots10312063_heriots
herls85226433_her_ls
hermits12312143_hermits
herms105626433_her_ms
hernias10310773_hernias
herns84825583_her_ns
heroes94923823_heroes
heroics122912003_heroics
heroins103518013_heroins
herons94820543_herons
heros84930863_her_os
herpes115517323_herpes
herries104025073_herries
hers75844873_her__s
inherits11310103inherits
jerids142810943_jerids
kerfs125413573_ker_fs
khalifs1754073khalifs
merits8320873_merits
neifs85613043_ne_ifs
peeries93623023peeries
perils84121853_perils
peris75537073_peri_s
pterins9812993pterins
queries16315873queries
reifs84819093_re_ifs
rerigs74014793_rerigs
rifs74929003___rifs
sanserifs1244663sanserifs
sarins63932623s_arins
saris54544953s_ari_s
sauries72821623sauries
scarfs114714683scar_fs
scarify1537443scarify
scenics1137773scenics
scherzos2243703scherzos
schriks16185743schriks
scorify1535203scorify
scries85226823s_cries
scrims104615933s_crims
scrips105316033s_crips
scurfs113210813scur_fs
seeress7311573seeress
seers55136383seer__s
seif75638733s_e_if_
seis45542393s_e_i_s
selfs85220243s_e_lfs
semis74623533s_emi_s
sepias83616103s_epias
seracs84418573s_eracs
serails73318363s_erails
serais64326133s_erais
sereins73716113s_ereins
seres55448893s_er_es
serf76340113s_er_f_
serfish1348973s_erfish
serges74225973s_erges
serial64625863s_erial
serials73919743s_erials
serifed11811463s_erifed
serin55434443s_eri_n
serine65432673s_erine
serines74229543s_erines
sering74731813s_ering
serious73616283s_erious
serous65023563s_erous
serows96016393s_erows
serries73925353serries
sers45746653s_er__s
serums83916303s_erums
serves94423653s_erves
servos93812723s_ervos
shadufs1433673shadufs
shairds11216263shairds
shairns10276783shairns
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
sharia93116733shari_a
shariah132210533shariah
shariahs14206393shariahs
sharing113723243sharing
sharks135019723shar_ks
sharns95516983shar_ns
sharpies13411223sharpies
sharps115516083shar_ps
shavies134213203shavies
sheaf115424123she_af_
sheals94420643she_als
shearers113911323shearers
shearing123915903shearing
shearings13337563shearings
shears93820903she_ars
sheas86331793she__as
sheaths1358753sheaths
sheaves134412973sheaves
sheds96122703she__ds
sheenies111411543sheenies
sheens95116993she_ens
sheering123715103sheering
sheers94322403she_ers
sheets93918503she_ets
sheeves133911953sheeves
sheik122514663she_i_k
sheikh16206993she_ikh
sheikhs17233993sheikhs
sheila969843she_ila
sheilas1059403sheilas
shekels1436043shekels
shelf115221113she_lf_
shells94319523she_lls
sheltas10279673sheltas
shelties111111383shelties
shelves134112093shelves
shends105313773she_nds
sheols94614163she_ols
sheqels1934753sheqels
sherbet12311383sherbet
sherbets1335213sherbets
sherd96321153sher__d
shereef1337743shereef
sheroot10414373sheroot
sheroots1137863sheroots
sherpa1138093sher_pa
sherrises12156863sherrises
sherry124510413sher_ry
shes75734353she___s
sheuchs15234933sheuchs
sheughs14264533sheughs
shewers134312053shewers
shewing143812193shewing
shews115924713she__ws
shiers94921753shier__s
shies86136553sh__ies
shift114225143sh__ift
shifts124412943sh__ifts
shims104422553sh__ims
shins85131043sh__ins
ships105123773sh__ips
shires95225573shir_es
shirks134814123shir_ks
shirrs94413173shir_rs
shirts94918343shir_ts
shits84731173sh__its
shivs115018803sh__ivs
shoers94518333shoer__s
shogis103810943shogi_s
shojis16348493shoji_s
shorans102812413shorans
shores94830413shor_es
shoring112820073shoring
shorings12269483shorings
shorls94516203shor_ls
shortias1148093shortias
shorties11414583shorties
shorts95321743shor_ts
shreds105613053sh_reds
shrews129313923sh_rews
shri76021703sh_ri__
shriek134211103sh_riek
shrieks14377673sh_rieks
shrike134513243sh_rike
shrikes144412393sh_rikes
shrill94712303sh_rill
shrills10389933sh_rills
shrimp13478773sh_rimp
shrimps14516753sh_rimps
shrine94920053sh_rine
shrines104618693sh_rines
shrink134511733sh_rink
shrinks14397913sh_rinks
shrive125216953sh_rive
shrives134416173sh_rives
shroff1538503sh_roff
shroffs1634363shroffs
shrubs11409213sh_rubs
shrugs10469163sh_rugs
shtiks13297833sh_tiks
shyers124712203shyer__s
sierras737863sierras
skeins103911903ske_ins
skerries12168673skerries
smerks12449713smer_ks
snarfs95113423snar_fs
sparids103512123sparids
species11314133species
specify1764993specify
speils84116223spe_ils
speirs85013233spe_irs
speiss84311643spe_iss
sperms102512603sper_ms
spheres123114353spher_es
spheric14510073spheri_c
spherier1337783spherier
spheriest1438373spheriest
sphering142811943sphering
spheroids1545543spheroids
spirits94112623spirits
sprigs94814773s_prigs
sprits85122533s_prits
sris45434153s__ri_s
stearins8312143stearins
steins64818343ste_ins
stereos74314973stereos
steres63929533ster_es
steric8317063steri_c
sterile7316603sterile
sterns64616763ster_ns
steroids9911443steroids
sterols7313443sterols
sthenias1178163sthenias
stories7324273stories
strife95318363s_trife
strifes104716583s_trifes
strips85719653s_trips
suberins10315093suberins
suers55128483suer__s
surfs85022543s_ur_fs
swarfs125612063swar_fs
swerves1377533swerves
theins95015423the_ins
theirs94610353the_irs
theories11311593theories
theres96525473ther_es
theriac1239143theriac
theriacs1336543theriacs
therian10311293therian
therians1138313therians
thermes126214613thermes
thermits1338513thermits
thermos124610753thermos
therms115914873ther_ms
thesis94913733thesi_s
thorias102312053thorias
thrift12412043th_rift
thrifts1335523th_rifts
thrips11299013th_rips
tusheries1246893tusheries
ushering1258923ushering
ushers94415533usher__s
veeries102916893veeries
verify153110163_verify
wharfs1546373whar_fs
whereas13448903whereas
wheres125917433wher_es
wherries14179023wherries
wherves16548053wherves

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 Filter1786911340270.513348325.5
2DLD Change Limit1340273068.28316181.0
3Display Results3063060.1102781.8
 (SQL Overall)1786913068.90620064.1
 
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.