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

382 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
derivers12381136(None) 
delivers123310751delivers
deprivers1545211deprivers
deriders102411851deriders
deriver114213911deriver_
derives114017811derive_s
drivers114412791d_rivers
arrivers11137002arrivers
deceivers1535722deceivers
deciders123510752deciders
decriers11299732decri_ers
defiers113913992defi_ers
defilers12439472defilers
definers124211192definers
deicers103612732de_icers
deliver113312242deliver_
delivery15286552delivery
delvers113411992de_lvers
deniers84515182deni_ers
depravers1534682depravers
depriver1446292depriver_
deprives1438392deprive_s
derider93214972derider_
derides93420852deride_s
deringers1137182deringers
derive103817042derive__
derived123912762derive_d
desilvers13306082desilvers
desirers939262desirers
devisers12339862devisers
divers105024962d__ivers
driers74516732d_ri_ers
drivels11397922d_rivels
driver104714492d_river_
drives105117112d_rive_s
drovers115212642d_rovers
reivers105117082re_ivers
revivers14389632revivers
rivers94626542__rivers
servers103214832ser_vers
shrivers14419102shrivers
strivers113911842strivers
thrivers14456822thrivers
uprivers13215562uprivers
vetivers1435162vetivers
aerier64823153aeri_er_
aeries64737783aeri_e_s
aivers94822323__aivers
arriver10117793arriver_
arrives101311513arrive_s
beavers124417323be_avers
bedrivels1542713bedrivels
behavers16205613behavers
beliers94617383beli_ers
believers14346633believers
bereavers1446123bereavers
beriberi1243453beriberi
beriberis1343523beriberis
berimes115216643berime_s
beshivers1743713beshivers
bravers124715523_bravers
breviers1335923breviers
bribers114111503_bribers
briers85319733_bri_ers
briners94315633_briners
buriers94017193buri_ers
carvers124817533car_vers
ceilers93912533ce_ilers
cerises94722253cerise_s
cerites94823433cerite_s
clivers123411753_clivers
coderives1547483coderive_s
codrivers1544863codrivers
cravers124416553_cravers
criers83918583_cri_ers
daikers124010313d_aikers
darers75921873dar__ers
darners83815773dar_ners
darters84017603dar_ters
datives11310073dative_s
deairs74013783deai__rs
dealers84118613de_alers
dearies83526273deari_e_s
deaves105319533de_ave_s
debasers11377903debasers
debaters113511923debaters
deboners11268113deboners
debrides1268723debride_s
debriefers1641653debriefers
debriefs1433533debri_efs
decayers14307963decayers
deceiver1436233deceiver_
deceives1437903deceive_s
deciares11510633deciares
decibels1344523decibels
decider114213183decider_
decides114217653decide_s
deciles104417723decile_s
deciphers1744393deciphers
deckers144413833de_ckers
decliners12358613decliners
decoders122810413decoders
decoyers14287713decoyers
decreers11277623decreers
decrier102713553decri_er_
decries103319803decri_e_s
deers64930523de___ers
defacers14237993defacers
defamers14258523defamers
defers105116943de__fers
defier105118653defi_er_
defies104624053defi_e_s
defiler113911883defiler_
defiles114016843defile_s
definer114413773definer_
defines114118683define_s
defrayers1644173defrayers
defusers12487363defusers
degraders12245933degraders
deicer94114413de_icer_
deices94119373de_ice_s
deifiers12348993deifiers
delayers12268663delayers
delimes10314193delime_s
delivered1445033delivered
deliverer1344503deliverer
deliverers1443663deliverers
deliveries1446013deliveries
deluders10156433deluders
delver104913493de_lver_
delves104917083de_lve_s
demies94825803demi_e_s
demireps1343993demireps
demises103719563demise_s
demisters1249203demisters
dendrimers1442743dendrimers
denier74420693deni_er_
denies74729643deni_e_s
denizens1835573denizens
denuders10165873denuders
depicters1435823depicters
deposers11359243deposers
depraver1435413depraver_
depraves1436873deprave_s
deprivals1543533deprivals
deprive1338303deprive__
deprived1546463deprive_d
derangers1136703derangers
derates84028893derate_s
derbies103016053derbie_s
deride84420033deride__
derided102914253deride_d
deringer1038143deringer_
derisory1245163derisory
derivate12311203derivate
derivates13310093derivates
deriving132510743deriving
dermises112512023dermise_s
dernier83011943dernier_
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
derringers1243843derringers
derrises93012783derrise_s
describers1543583describers
descriers1245693descri_ers
deservers13107293deservers
designers1136003designers
desilver12286503desilver_
desirer8310783desirer_
desires81316133desire_s
despisers1245153despisers
destriers1038143destri_ers
detailers10257253detailers
detainers10269103detainers
deters74724683de__ters
detickers1634423detickers
devels104313903de__vels
devices133212583device_s
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
dewaters122910723dewaters
dewier104013463dewi_er_
dewiness1238453dewiness
dexies145018343dexi_e_s
dicers94720743d__icers
dikers114418793d__ikers
dimers94321093d__imers
diners75525953d__iners
diver94827803d__iver_
diverse11429993d__iverse
divert103922813d__ivert
diverts114412033d__iverts
dives95832403d__ive_s
dividers13257213dividers
diviners12308353diviners
dories75232363dori_e_s
dormers104313923dor_mers
dorpers104113173dor_pers
dorsers83516303dor_sers
drainers92811253drainers
drapers105313353d_rapers
drawers113610073d_rawers
dreamers11369003dreamers
dredgers11256093dredgers
dreidels1033213dreidels
dressers9359863dressers
drier64423963d_ri_er_
dries64733673d_ri_e_s
drifters12417913d_rifters
drillers9429723d_rillers
drinkers13277823d_rinkers
drippers13327943d_rippers
drive95318003d_rive__
drivel105110383d_rive_l
drivelers1364223d_rivelers
driven105210143d_rive_n
droners84114383d_roners
drover104614593d_rover_
droves105116673d_rove_s
dryers10449273d_r_yers
duikers12369383d_uikers
eerier64320023eeri_er_
eeriness8311873eeriness
eiders74321363_e_iders
elvers93814983_e_lvers
enviers1036993_enviers
epimers11109493_epimers
erasers74413943_erasers
exilers14419733_exilers
fervors1336233fer_vors
fevers125414893fe__vers
fivers124420923__fivers
forevers1438173forevers
forgivers1643713forgivers
friers94718933_fri_ers
frizers19329553_frizers
givers104817713__givers
gravers114515273_gravers
grievers1255473_grievers
gripers104011463_gripers
grivets11357973_grivets
heavers133717193he_avers
heifers1337933he_ifers
herders113914123her_ders
heritors11310903heritors
jerkers18287083jer_kers
jivers164515643__jivers
leavers103717783le_avers
levers94621323le__vers
leviers103510343levi_ers
livers94927823__livers
lorimers1036613lorimers
loriners839963loriners
mariners103113863mariners
mercers114412773mer_cers
mergers103813423mer_gers
merises93421423merise_s
metiers93312843meti_ers
minivers1337483minivers
nerves94216193ner_ve_s
nervier10298833nervier_
perceivers1743893perceivers
perchers153611523perchers
periderm1346803periderm
periderms1444993periderms
perigees1189503perigees
peripters1368123peripters
perusers10328803perusers
perverse1336103per_verse
pervert12315583per_vert
perverts1337533per_verts
preavers13910263preavers
pricers113915063_pricers
priers84521193_pri_ers
primers114215673_primers
privets122910053_privets
prizers183911843_prizers
provers123817793_provers
queriers1736963queri_ers
quivers19298753_quivers
ravers94628183__ravers
reavers108320743re_avers
receivers1436363receivers
reciters102613113reciters
recovers133511123recovers
redelivers1443553redelivers
redrives122610393redrive_s
refiners114713313refiners
regives115014213regive_s
reiver95318293re_iver_
reives95723043re_ive_s
reliers75519213reli_ers
relievers12387063relievers
relives104619443relive_s
removers13449223removers
repiners103913433repiners
reprovers14217773reprovers
rerises73525883rerise_s
residers93311883residers
resilvers12306503resilvers
retirers84311533retirers
retrievers1373303retrievers
revers94529633__revers
revilers114011693revilers
revisers113511933revisers
reviver134411373reviver_
revives134715543revive_s
rewriters1236343rewriters
ricers84120993__ricers
riders74123903__riders
rievers104311453__rievers
rimers84522553__rimers
risers64624783__risers
river85731693__river_
rives85336003__rive_s
rivets94417113__rivets
rovers95423523__rovers
scribers12307963scribers
scrives124414273scrive_s
seiners74219273se_iners
seisers73816393se_isers
seizers164112503se_izers
sergers83815633ser_gers
series64540973seri_e_s
serines74229543serine_s
serovars1145233serovars
server94917713ser_ver_
serves94423653ser_ve_s
servicers1444663servicers
severs94121123se__vers
shivers133714833_shivers
shrivels14376443shrivels
shriver134712193shriver_
shrives134416173shrive_s
sivers95324153__sivers
skivers14409703_skivers
slivers104115253_slivers
stivers103613543_stivers
striders94412123striders
strikers123611293strikers
stripers103911593stripers
striver104315203striver_
strives104119373strive_s
stuivers11406673stuivers
survivers1543883survivers
swervers1455213swer_vers
termers95414503ter_mers
terriers84210823terriers
thriver13479123thriver_
thrives134611713thrive_s
triers64321523_tri_ers
trimers94615143_trimers
trivets103911583_trivets
trovers103713323_trovers
uprisers10206773uprisers
upriver12196933upriver_
variers103712663vari_ers
veilers103911823ve_ilers
veiners104112523ve_iners
veligers1237023veligers
verditers1344993verditers
vergers114412633ver_gers
verier94620963veri_er_
verifiers15166063verifiers
verites103822263verite_s
verniers11227843verniers
versers103813523ver_sers
verves124617883ver_ve_s
vervets13419753ver_vets
vetiver1336103vetiver_
vetivert1446753vetivert
vetiverts1542343vetiverts
vivers124717363__vivers
waivers133410053_waivers
weavers133714463we_avers
weevers13379993we_evers
weiners103913063we_iners
wivers125320803__wivers
writers105513493_writers

Search took 8 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.440406115.9
2DLD Change Limit1461623826.73321708.3
3Display Results3823820.1402728.6
 (SQL Overall)1786913827.31324434.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.