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

390 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
diverts11441203(None) 
divers105024961diver_s
divert103922811divert_
divests114510931divests
adverts11308512adverts
aivers94822322aiver_s
averts95715242_averts
civets115212542cive_ts
coverts124813812coverts
deserts82513052deserts
devests114410472devests
dicers94720742dicer_s
diets66026642di_e_ts
digests93610612digests
dikers114418792diker_s
dimers94321092dimer_s
dineros83812332dineros
diners75525952diner_s
directs102710262directs
dirts66824462di__rts
disserts92411812disserts
diver94827802diver__
diverge12347642diverge
diverges13258312diverges
diverse11429992diverse
diverted13199582diverted
diverter12238622diverter
diverters13227862diverters
dives95832402dive__s
divest106820072divest_
divots104712202div_ots
drivers114412792driver_s
duvets1039222duve_ts
everts94514892_everts
fivers124420922fiver_s
givers104817712giver_s
inerts64517022_inerts
inverts103211952inverts
jivers164515642jiver_s
livers94927822liver_s
obverts1235402obverts
reverts104715042reverts
rivers94626542river_s
rivets94417112rive_ts
sieverts1145712sieverts
sivers95324152siver_s
verts85724732__verts
vivers124717362viver_s
wiverns13366962wiverns
wivers125320802wiver_s
advects13276013advects
advents11309473advents
adverbs13254273adverbs
advert103215773advert_
aiders74524633aider_s
aigrets82810533aigrets
aimers84621913aimer_s
airers64922313airer_s
airts55626343ai__rts
aiver85725163aiver__
alerts64418223_alerts
ambiverts1642503ambiverts
asserts74311793asserts
avers85127313_aver_s
avert86029493_avert_
biders94822803bider_s
bidets95215533bide_ts
biers76225223bi_er_s
bikers124517553biker_s
biners85023633biner_s
bisects1137133bisects
biters83925233biter_s
caveats1239803caveats
caverns124510243caverns
cavers115026833caver_s
cavorts1237933cavorts
cherts115617233_cherts
ciceros1158573ciceros
ciders94620083cider_s
citers85022973citer_s
civet105828733cive_t_
clivers123411753cliver_s
converts133213553converts
covers114627963cover_s
covert114925503covert_
covets114819643cove_ts
culverts13295313culverts
daikers124010313daiker_s
darers75921873darer_s
darts67635733d__arts
daters74827363dater_s
davens104612913dave_ns
davits104012363dav_its
debts86418373d__ebts
deceits102810883deceits
decerns10119053decerns
deers64930523d_eer_s
deets65330243d__eets
defeats113511233defeats
defects134511523defects
defers105116943defer_s
degerms1135623degerms
dehorts11379773dehorts
deicers103612733deicer_s
dejects17389223dejects
delivers123310753deliver_s
delts65731793d__elts
delvers113411993delver_s
dements103016623dements
demerits11310763demerits
dents65031803d__ents
departs104310683departs
deperms1236603deperms
deports105012883deports
derats74625063d__erats
derivers123811363deriver_s
derms85022893d__erms
desert72725493desert_
desserts9247923desserts
detects104011093detects
detents83615153detents
deters74724683deter_s
detests83711743detests
deveins1138803deveins
devels104313903deve_ls
devest104418703devest_
dialects11126003dialects
dialers83614293dialer_s
diapers104713893diaper_s
dibbers124013173dibber_s
dicasts1078703dicasts
dicer85426423dicer__
dices86434243dice__s
dickers144117663dicker_s
dicots94915793di_cots
didacts1186063didacts
dienes75719903di_enes
dies55653523di_e__s
dieses75218693di_eses
diesis74013493di_esis
diet57357533di_e_t_
dieters83216423dieter_s
differs14339973differ_s
digerati1047393digerati
digest84019623digest_
diggers104413383digger_s
dights114016963di_ghts
digits84114533di_gits
diglots9299503diglots
digress938323digress
diker105524553diker__
dikes105831333dike__s
diktats1235623diktats
diluents946053diluents
dimer85625603dimer__
dimeric12310013dimeric
dimerism1347213dimerism
dimerous1139323dimerous
dimes85833043dime__s
dimmers123811563dimmer_s
dimouts1037893dimouts
dimwits1344503dimwits
dinars75417563dinar_s
diner65632903diner__
dineric10310973dineric
dinero75612643diner_o
dines66449153dine__s
dinette8310013dinette
dinettes9310193dinettes
dingers94321373dinger_s
dinners83915433dinner_s
dints67431313di__nts
dipnets10109033dipnets
dippers123615173dipper_s
diquats1745973diquats
direct93817333direct_
direr64927073direr__
direst75024243direst_
dirks105619523di__rks
dirls64720503di__rls
dirt55550383di__rt_
dirty95617803di__rty
disarms1039043disarms
discepts1336743discepts
discerns1138163discerns
diseurs839403diseurs
disherits1348233disherits
disjects18275923disjects
disparts11109953disparts
disports111111113disports
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
dissert83720693dissert_
distorts91112343distorts
dites66339153dite__s
dithers114016153dither_s
dits56450523di___ts
divans104612393div_ans
divas95418583div__as
dive85634773dive___
dived106321373dive__d
diverged14256883diverged
diversity1645213diversity
diverting142410333diverting
divested13268213divested
dividers13257213divider_s
divides123211453divides
diviners12308353diviner_s
divines113514723divines
divorce1344813divorce
divorces1445673divorces
divot95723073div_ot_
divvies1457663divvies
dixits144210313di_xits
dizens164911393dize_ns
docents102810803docents
doers65225713d_oer_s
dopers95522483doper_s
dosers75723633doser_s
doters74423913doter_s
dovecots1444323dovecots
dovens104413903dove_ns
doves94728153dove__s
dowers104523293dower_s
dozers164815423dozer_s
driers74516733drier_s
drivels11397923drive_ls
driver104714493driver__
drives105117113drive__s
drovers115212643drover_s
dryers10449273dryer_s
duets65323883d_ue_ts
duikers12369383duiker_s
dupers94615603duper_s
duvet9321873duve_t_
dyers96617133d_yer_s
eiders74321363eider_s
elvers93814983elver_s
events94814073_events
evert84929513_evert_
exerts133712293_exerts
experts1659063experts
exserts1467013exserts
fevers125414893fever_s
fibers114717523fiber_s
fifers125414923fifer_s
filberts1334983filberts
filers94623723filer_s
filets94718953file_ts
firers94922683firer_s
fiver116024943fiver__
fives116027363five__s
fixers165112983fixer_s
gibers95114663giber_s
gilberts1134173gilberts
girts65423623gi__rts
givens10379733give_ns
giver94921203giver__
gives95324873give__s
governs1136103governs
grivets11357973grive_ts
havers124721483haver_s
hiders104919653hider_s
hikers135014353hiker_s
hirers94518063hirer_s
hives116925513hive__s
hovers124320253hover_s
idlers74012813idler_s
inert53234373_inert_
inserts74013993inserts
invents102812053invents
invert94120083invert_
invests10319683invests
jibers155912883jiber_s
jiveass1792163jiveass
jiver155119053jiver__
jives154820813jive__s
kiers95320093ki_er_s
kiters105218583kiter_s
lavers94526363laver_s
leverets11297603leverets
levers94621323lever_s
libers84721433liber_s
liberty1237153liberty
liers55130403li_er_s
lifers95617843lifer_s
ligers75022023liger_s
likers104620913liker_s
liners65428843liner_s
liters65429873liter_s
livens94314893live_ns
liver85132963liver__
livered113111633livered
liveries11314373liveries
liverish1447863liverish
livery124910893liver_y
lives86133193live__s
livest95315733livest_
liviers104211073livier_s
livres94311863liv_res
livyers13365903livyer_s
lovers94223433lover_s
milers84625163miler_s
mimers105520183mimer_s
miners84126633miner_s
miseats92815783miseats
misers85025703miser_s
miters84328773miter_s
mixers154513563mixer_s
movers115117193mover_s
nerts55924983__nerts
niters64624203niter_s
niveous1037193niveous
obvert11412993obvert_
oilers64721193oiler_s
overs85224793_over_s
overt85630723_overt_
pavers115021823paver_s
perverts1337523perverts
piers75926333pi_er_s
pikers124717393piker_s
pipers104318663piper_s
pipets105714773pipe_ts
pivots115111903piv_ots
poverty1536433poverty
privets122910053prive_ts
qiviuts1942893qiviuts
quivers19298753quiver_s
ravers94628183raver_s
reivers105117083reiver_s
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
revert93529113revert_
revests104413733revests
revets94022173reve_ts
ricers84120993ricer_s
riders74123903rider_s
rievers104311453riever_s
rimers84522553rimer_s
risers64624783riser_s
river85731693river__
rives85336003rive__s
rivet85636363rive_t_
rivieras1143573rivieras
rivieres1136013rivieres
rovers95423523rover_s
savers93825923saver_s
severs94121123sever_s
shivers133714833shiver_s
sievert10613293sievert_
silents73514493silents
silvers104714033silver_s
siver85728613siver__
sizers155215813sizer_s
skivers14409693skiver_s
slivers104115253sliver_s
stivers103613533stiver_s
subverts1336973subverts
swivets13436963swive_ts
taverns10317803taverns
tiers55526523ti_er_s
tigers75616503tiger_s
tilers63523493tiler_s
timers84420993timer_s
titers64526403titer_s
trivets103911583trive_ts
vents86125933__vents
verbs104614393__verbs
verst84429373__verst
versts93914733__versts
vert77249373__vert_
vertu85017613__vertu
vertus94613603__vertus
vests85325983__vests
vetiverts1542343vetiverts
vets76835093__ve_ts
viers85621953vi_er_s
vipers114914533viper_s
waivers133410053waiver_s
wavers125022473waver_s
wipers115416083wiper_s
wirers94617893wirer_s
wisents10249063wisents
wiver115924513wiver__
wivern12409283wiver_n
wives115328923wive__s
wyverns16363013wyverns
zibets1737743zibe_ts

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273907.48617903.7
3Display Results3903900.1233170.7
 (SQL Overall)1786913907.76223021.3
 
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.