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

399 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
aborter93993(None) 
aborted10310421aborted
aborters1038571aborters
abater85518122ab_ater
abetter958322abetter
abhorrer1343402abhorrer
abort76133582abort__
aborts84916182abort_s
abortus9397912abortus
absorber1254312absorber
abutter957512abutter
adopter1036762adopter
adorer74713452ador_er
adorner8246982adorner
alerter72111512alerter
assorter866672assorter
averter102410552averter
barter85525372_barter
boater84622092_boater
bolter83920752_bolter
border94419972_border
borer75131272_bor_er
cavorter1335782cavorter
laborer9249512labor_er
porter84224412_porter
shorter103515502shorter
snorter74412662snorter
sorter64425092_sorter
sporter93616552sporter
taborer9269292tabor_er
abaser86414343ab_aser
abate76627843ab_ate_
abated95918453ab_ated
abaters95115203ab_aters
abates85825033ab_ates
abator84512723ab_ator
abetted1058323abetted
abetters1057173abetters
abettor956193abettor
abhorred1443503abhorred
abhorrers1442983abhorrers
abider95314463ab_ider
abjurer1634753abjurer
ablate82219213ablate_
ablated102513443ablated
ablates92416903ablates
ablator939853ablator
abler75624313ab__ler
abluted10188363abluted
abode85518813abo_de_
aboded104912513abo_ded
abodes94417513abo_des
aboiteau1042713aboiteau
aboral8314373abor_al
aborting11710253aborting
abortion1048103abortion
abortive1346883abortive
abortuses1144993abortuses
about75229083about__
above105414323abo_ve_
aboves114512843abo_ves
abrader1038643abrader
abrupter1243793abrupter
absenter1086773absenter
absoluter1142923absoluter
absolver1343693absolver
absorbed1344263absorbed
absorbers1353983absorbers
absurder11134363absurder
abuser85413683ab_user
abutted1056983abutted
abutters1056993abutters
accorder1395253accorder
accouter1245363accouter
acerber1135243acerber
acorned10238283acorned
acuter84412863a_cuter
adapter1036173adapter
adepter1036113adepter
adopted1136253adopted
adoptee1048413adoptee
adopters1136693adopters
adore65723673ador_e_
adored84714243ador_ed
adorers84411733ador_ers
adores74420723ador_es
adorned9256893adorned
adorners9196623adorners
adroiter946193adroiter
adsorber1143503adsorber
aerier64823153a_erier
afore85818603afor_e_
after85719793a__fter
agorae7511203agorae_
ahorse9311513ahorse_
airer54927893a_ir_er
airier64619363a_irier
airted74214503a_irted
alerted82512223alerted
allotter866473allotter
alter54828503a__lter
amercer1146373amercer
ammeter1148393ammeter
amort75832203amort__
angrier839023angrier
anointer837823anointer
another10289153another
aorta55922573a_ort_a
aortae65115473a_ortae
aortal65217513a_ortal
aortas65417783a_ortas
aortic8316613a_ortic
aport75432173aport__
apter76120203a__pter
arbiter939933arbiter
arbored103811603arbor_ed
arbores94016033arbor_es
arboreta1045223arboreta
armer76924443a__rmer
armorer9259913armor_er
arouser74514423arouser
artel56122743a__rtel
artery9911453a__rtery
artier63419733a__rtier
asserter877573asserter
assorted956603assorted
assorters965733assorters
aster55434893a__ster
atoner64817193ato_ner
averted112211613averted
averters11249513averters
avoider1155813avoider
avower1236823avo_wer
awaiter1057443awaiter
awarder1135893awarder
azote144416343azo_te_
azoted16388593azo_ted
azotes154312223azo_tes
baiter84422553_baiter
banter84825333_banter
barber104419323_barber
barer74535803_bar_er
barker124822863_barker
barrater10310143barrater
barrier94017733barrier
barters94223033_barters
baster85333593_baster
batter84928873_batter
beater84729393_beater
belter84720963_belter
better84723703_better
birder94915493_birder
birler85715083_birler
bister84922763_bister
biter75030033_b_iter
bitter84622673_bitter
bloater94013423bloater
blotter94612853blotter
blurter9419833blurter
boarder103910323_boarder
boaster94616433_boaster
boated94221973_boated
boatel84314093_boatel
boaters93419243_boaters
bobber95016743_bobber
boiler84319273_boiler
boite74426323_boite_
boites84322703_boites
bolder94820933_bolder
bolster93713423_bolster
bolted94617803_bolted
bolters94017803_bolters
bomber125014653_bomber
bonder95324783_bonder
boner75133083_bo_ner
bonier84321993_bonier
bonzer175313673_bonzer
booger94816553_booger
booker124719193_booker
boomer104618513_boomer
booster94314553booster
booted94822733_booted
bootee84323023_bootee
bootery1238983_bootery
boozer174815963_boozer
bopper123813833_bopper
borate85026153_borate_
borated104116363_borated
borates94823013_borates
bordel94514573_bordel
borders104317533_borders
bore66051333_bor_e_
bored85034303_bor_ed
boreen8314313_boreen
borers85122683_bor_ers
bores76448253_bor_es
borked135117293_borked
borne77926793_borne_
bort65960963_bort__
borts76735453_bort_s
borty105522833_bort_y
bortz165722203_bort_z
bortzes1838223_bortzes
bosker123813653_bosker
botel75121863_bo_tel
bother115218063_bother
bottler94211883_bottler
bower107328183_bo_wer
bowler114217313_bowler
bowyer14368923_bowyer
boxer145016523_bo_xer
boxier154311743_boxier
brier74527403_b_rier
broker124314243_broker
brother123311333_brother
bunter85020383_bunter
burger94020793_burger
burier84324653_burier
burker125221173_burker
burler84723833_burler
burner83819203_burner
burrer83718473_burrer
burster9310293_burster
buster84726493_buster
butter84724233_butter
carter84932273_carter
cavorted1435693cavorted
cavorters1434973cavorters
charter123918303charter
chorten122811303chorten
chortler13336843chortler
clouter93511693clouter
coater84329573_coater
colter84625093_colter
cooter85128613_cooter
copter109822013_copter
corder94322883_corder
corer75538873_cor_er
corker124720853_corker
corner84625623_corner
cortex15311473_cortex
coster84331293_coster
cotter84926673_cotter
courter94516483courter
couter84930223_couter
crofter12299573crofter
curter85320083_curter
dabster1036703dab_ster
darter75320363_darter
deporter1169393deporter
diopter1038473diopter
dormer94415903_dormer
dorper94314573_dorper
dorser74819183_dorser
doter65428623_do_ter
dotter74419343_dotter
emborder1345083emborder
emoter85415193emo_ter
exhorter1845353exhorter
exporter1737363exporter
extorter1546513extorter
fagoter1135883fago_ter
favorer1355883favor_er
flirter10318673flirter
floater104413353floater
flouter104311343flouter
footer94320773_footer
forcer114917343_forcer
forger104820773_forger
forker134717903_forker
former114221403_former
forte86131463_forte_
fortes95327183_fortes
foster94322223_foster
fronter103611583fronter
garotter965943garotter
garroter956573garroter
garter74420513_garter
gloater83711013gloater
goiter74116203_goiter
gorger86116983_gorger
gorier73719373_gorier
grouter84412523grouter
harborer1348053harbor_er
hooter94123933_hooter
hotter94720083_hotter
hurter93915853_hurter
importer12308913importer
jolter133513093_jolter
jotter134315633_jotter
knotter11317643knotter
labored102810253labor_ed
laborers10208383labor_ers
laborite10410703laborite_
laborites1149263laborites
labourer1045763labourer
lobster9288853lobster
lofter94614723_lofter
loiter64619173_loiter
looter64222323_looter
lotter64025603_lotter
mobster11299213mobster
molter84119423_molter
moorier93113073moorier
mooter83921093_mooter
mortar83812043_mortar
norther1039733_norther
noter55025643_no_ter
oater55433733__oater
ofter84116873__ofter
order65019363__order
ormer75218373__ormer
otter54423973__otter
outer55633303__outer
oxter123414093__oxter
parroter1058203parroter
pearter9412743pearter
perter84422283_perter
plotter94113663plotter
poofter1237163poofter
poorer82613993poor_er
porker124917543_porker
ported94223243_ported
porters93722703_porters
poster84129173_poster
potter83926983_potter
pouter83923983_pouter
powter114116033_powter
quarter163211853quarter
quoter153510093quo_ter
rabbiter1234673rabbiter
reorder8239483reorder
reporter10411423reporter
resorter8312183resorter
retorter8410733retorter
rioter64817283rio_ter
rooster74415173rooster
rooter64926033_rooter
roster64329083_roster
rotter64325463_rotter
router65025843_router
saboteur1042003sabo_teur
savorer1057883savor_er
savorier1136643savorier
scooter93312873scooter
scorer84818263scor_er
scorner9259763scorner
scoter83815483sco_ter
scouter93313323scouter
shooter103013993shooter
shorted113614403shorted
shorten103511413shorten
shouter103213083shouter
skirter11338483skirter
slotter73314453slotter
smarter94113133smarter
snorer64316763snor_er
snorted83813493snorted
snorters83410583snorters
softer94015313_softer
sorer56236593_sor_er
sorner64720393_sorner
sorted74523713_sorted
sorters74221133_sorters
souter64225923_souter
sported104015433sported
sporters103714063sporters
sportier102010053sportier
spotter94514883spotter
spouter94213223spouter
spurter94013003spurter
starter73817883starter
storer64721673stor_er
stouter74012053stouter
suborder1146663suborder
suborner1047383suborner
swotter10399473swotter
tabored102810563tabor_ed
taborers10268333tabor_ers
taboret92916113tabor_et
taborets10278063taborets
tabourer1035743tabourer
tarter64023563_tarter
tooter64420803_tooter
torte55431703_torte_
torten65314353_torten
tortes64826053_tortes
toter55932133_to_ter
totter65021463_totter
touter63821033_touter
trotter73312253trotter
unaborted1245733unaborted
vaporer1236983vapor_er
vortex1635923_vortex
voter85121053_vo_ter
worker134715113_worker
wormer114514913_wormer
worser95117523_worser
zoster153715853_zoster

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.420425454.8
2DLD Change Limit1340273996.61020276.4
3Display Results3993990.1402850.0
 (SQL Overall)1786913997.17024922.0
 
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.