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

182 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
spherier133778(None) 
sneerier878102sneerier
sparrier10329142sparrier
speedier1146622speedier
sphere113313662spher_e_
sphered133512312spher_ed
spheres123114352spher_es
spheric14510072spheri_c
spherics1537072spherics
spheriest1438372spheriest
sphering142811942sphering
spiderier1244652spiderier
spirier93214072sp_irier
sprier84119062sp__rier
spurrier10297692spurrier
adherer1137573adher_er
aerier64823153__aerier
aperies9423203ap_eries
aphorizer2345403aphorizer
asperser10408303asp_erser
aspheric1547983aspheri_c
beerier93613023_beerier
charier124317903_charier
cheerier1348003cheerier
chertier1387873_chertier
chewier1537593_chewier
cipherer1545573cipher_er
coherer122912783coher_er
eerier64320023__eerier
etherizer2145983etherizer
fierier103511193_fierier
herbier1239593__herbier
herder104516463__herder
leerier73111503_leerier
onerier7311613_onerier
ornerier846043ornerier
parrier93717653_parrier
peerie83617893_peerie_
peeries93623023_peeries
perkier133813123_p_erkier
perter84422283_p_erter
phonier122710633_phonier
piercer11337773_piercer
premier113515633_premier
prier75027763_p__rier
querier16310013_querier
savorier1136643savorier
scarier94017873s_carier
scarrier10298453scarrier
schemer1477963sche_mer
schizier2234063schizier
screwier1346433screwier
seedier83513633s_eedier
seepier92912013s_eepier
serer55935513s__er_er
serger73819743s__erger
series64540973s__eries
server94917713s__erver
severer103511563sever_er
sexier13310683s__exier
shadier113111153s_hadier
shakier143411153s_hakier
shalier103116423s_halier
sharer95025483s_har_er
sharker144313813s_harker
sharper124312703s_harper
shearer104414683s_hearer
shedder12339323s_hedder
sheenier11167423sheenier
sheer84726893s_he__er
sheerer103813843s_heerer
sheeter103814913s_heeter
sheller103515883s_heller
shellier1138393s_hellier
shelter103214963s_helter
shelver134211063s_helver
shelvier1464913s_helvier
sherbert1348793s_herbert
sherbet12311383s_herbet
shereef1337743s_hereef
sherif122915243s_heri_f
sheriff16287693s_heriff
sherifs13299683s_herifs
sherries111812893s_herries
shewer124515113s_he_wer
shier85428943s_h__ier
shinier104113143s_hinier
shirker143711343s_hirker
shirtier1137943s_hirtier
shorter103515503s_horter
showier1339103s_howier
shriek134211103s_h_riek
shriver134712193s_h_river
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
slipperier1442703slipperier
smearier1036953smearier
sneerer73512313sneer_er
sneezier1774333sneezier
soberer93110353sober_er
sorrier72313733s_orrier
spacier114011633sp_acier
sparer84524963sp_ar_er
sparger103613083sp_arger
sparker133914363sp_arker
sparkier14298033sparkier
sparser94311483sp_arser
speaker133311213sp_eaker
spearer93913663sp_earer
specie10412223sp_ecie_
species11314133sp_ecies
specter113111733sp_ecter
speeder103811073sp_eeder
speer74623903sp_e__er
speered103614813speer_ed
speering113116323speering
speir75315363sp_e_i_r
speired103811103sp_eired
speller95415143sp_eller
spelter94113703sp_elter
spencer113610973sp_encer
spender103713693sp_ender
spendier1147143spendier
spewer115112153sp_e_wer
sphene113412403sphe_ne_
sphenes123013163sphe_nes
sphenic1449093spheni_c
spheral1238423spher_al
spherical1645803spherical
spheroid1447283spheroid
spheroids1545543spheroids
spherular1442893spherular
spherule1343843spherule
spherules1443823spherules
sphery14318883spher__y
spiceries1349313spiceries
spicier115112463sp_icier
spieler93111233spie_ler
spier75728033sp___ier
spiered104412463spier_ed
spiering112713353spiering
spiffier16255883spiffier
spikier13369983sp_ikier
spinier93715163sp_inier
spleenier1143863spleenier
splurger1143813splurger
splurgier1252343splurgier
spongier1135743spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553sp_orter
sportier102010053sportier
spottier10207313spottier
spreader1137483spreader
sprucier1254793sprucier
spryer11418533sp__ryer
spumier1137903sp_umier
spunkier14235823spunkier
spurner9269653sp_urner
spurrer93710223sp_urrer
spurriers11245063spurriers
spurries102311323spurries
spurter94013003sp_urter
starrier8279463starrier
steelier839183steelier
steerer73113633steer_er
sterner7411913s_terner
sugarier937393sugarier
sultrier837773sultrier
summerier1346423summerier
superber1239693superber
superior10310883superior
sweepier1355493sweepier
swerver1365733s_werver
syphered1755013sypher_ed
syphering18175733syphering
thewier1336063_thewier
towerier1137123towerier
upheaver1643443upheaver
verier94620963__verier
waterier11312083waterier

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 Limit1461621826.37322934.6
3Display Results1821820.0802275.0
 (SQL Overall)1786911826.87625987.6
 
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.