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

260 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
aborning118800(None) 
aborting11710251aborting
adorning1087321adorning
abhorring1543542abhorring
aboding11410122abo_ding
abounding1335192abounding
absorbing1444472absorbing
adoring9412522ador_ing
aproning11311792aproning
atoning83514872ato_ning
attorning1045502attorning
barning104320352_barning
boning94223292_bo_ning
boring94724872_bor_ing
borking144716172_borking
burning104215502_burning
corning103720122_corning
horning113015002_horning
laboring112110142labor_ing
morning103215042_morning
scorning1169132scorning
sorning83116812_sorning
suborning1246682suborning
taboring113010192tabor_ing
thorning1237512thorning
abashing1466623abashing
abasing10610673ab_asing
abating10413973ab_ating
abducing1474063abducing
abegging1334483abegging
abetting1158293abetting
abiding11510503ab_iding
abjuring1834873abjuring
ablating11311993ablating
aborigine1244773aborigine
abortion1048103abortion
abortions1147783abortions
abortive1346883abortive
abrading1239503abrading
absenting1236993absenting
absolving1543323absolving
abusing1049113ab_using
abutting1137003abutting
abying124410413ab__ying
according1545273according
accruing1344033accruing
adjoining1844033adjoining
adjourning1981573adjourning
adopting1237453adopting
adsorbing1344113adsorbing
affording1744023affording
airing74927503a_ir_ing
airting83616303a_irting
alarming1138583alarming
alerting91312383alerting
aliening91510893aliening
aligning10158533aligning
alining81917043a_lining
amercing1337193amercing
amorini9310353amor_ini
amorino9310253amor_ino
amounting1236643amounting
anointing1038623anointing
arborizing2256643arborizing
arcing95819643a__rcing
arming94719803a__rming
armoring1149123armor_ing
arointing1049363arointing
arousing93811803arousing
aroynting1344633aroynting
arrowing1237943arrowing
assorting1037293assorting
attuning935903attuning
averring12239063averring
averting122512733averting
avoiding1336783avoiding
avowing1466603avo_wing
awarding1356043awarding
awning105013393a__wning
baning95127833_b_aning
banning103818233_banning
barbing123716993_barbing
barding113822893_barding
barfing134615093_barfing
barging114018483_barging
baring95135853_bar_ing
barking144724183_barking
barring104021593_barring
beaning103820683_beaning
berming123614823_berming
binning103615453_binning
birding114014923_birding
birling104317053_birling
birring103713063_birring
boarding123110233_boarding
boating103721303_boating
bobbing113113193_bobbing
boding104320063_bo_ding
bodying1438973_bodying
boffing16339983_boffing
bogging123615753_bogging
boiling103819673_boiling
boing84725553_bo__ing
boinking15378423_boinking
bolling103820883_bolling
bolting104416763_bolting
bombing143211383_bombing
bonding113318433_bonding
bonging113316373_bonging
bonking144116373_bonking
boobing123613913_boobing
booing94521643_bo_oing
booking143618383_booking
booming123716223_booming
booting103821363_booting
boozing194012163_boozing
bopping143512033_bopping
borating113414503_borating
borings103614243_bor_ings
bornite9311183_bornite
bossing103714603_bossing
bouncing13318773_bouncing
bounding123012133_bounding
bousing103718043_bousing
bowing124723063_bo_wing
bowling133916493_bowling
bowsing134012503_bowsing
boxing163915153_bo_xing
bring85528503_b_r_ing
brining103216473_brining
broking143514823_broking
bronzing2037693_bronzing
browning14299643browning
burking143716323_burking
burling104421133_burling
burnings11387623_burnings
burping124012943_burping
burring104016993_burring
burying133413913_burying
byrling13337373_byrling
cabining1338643cab_ining
caverning1536283caverning
cavorting1536063cavorting
chording15410153chording
choring133617663chor_ing
churning14237173churning
cloning103215473clo_ning
clowning14307253clowning
coining103920543_coining
coning94331823_co_ning
conning103718753_conning
cording113620823_cording
coring94433963_cor_ing
corking143018823_corking
crooning113112113crooning
crowning143510033crowning
darning93817333_darning
deboning12109153debo_ning
dehorning1455243dehorning
donning93512763_donning
downing123811673_downing
droning93013723dro_ning
drowning13298363drowning
durning93511733_durning
earning83418213_earning
eloining9310443eloining
favoring1596673favor_ing
foining113013453_foining
forcing134013753_forcing
fording123717033_fording
forging124114723_forging
forking154014843_forking
forming133615733_forming
frowning15307833frowning
girning93210693_girning
glorying1335543glorying
gorging102611363_gorging
goring84119573_gor_ing
gorming112810833_gorming
gowning12258833_gowning
groaning102410283groaning
groining102310633groining
hamboning1745893hambo_ning
harboring1538263harbor_ing
honing103421503_ho_ning
hording123517053_hording
hornings12238363_hornings
horsing113215583_horsing
inurning937553inurning
ironing82414013iro_ning
jawboning22133413jawbo_ning
joining153011483_joining
kerning124010893_kerning
kirning12319333_kirning
labouring1236213labouring
learning978553learning
loaning83614833_loaning
lording93115233_lording
majoring1836363major_ing
marooning1238593marooning
masoning1139763maso_ning
moaning103714443_moaning
mooning103415553_mooning
mooring102514443moor_ing
mornings11297903_mornings
mourning1156793mourning
nooning83014853_nooning
orbing93312353__orbing
owning104110333__owning
phoning13312053pho_ning
poring94227273_por_ing
porking143515813_porking
porting103021783_porting
quoining1835893quoining
ratooning1037173ratooning
razoring1836443razor_ing
readorning1245723readorning
reboring11312783rebor_ing
sabering112113743saber_ing
sabring102614843sab_r_ing
savoring1269483savor_ing
scoring103117213scor_ing
shoring112820063shor_ing
shorting122514793shorting
snoring83917203snor_ing
snorting92613373snorting
sorbing102815263_sorbing
soring74731883_sor_ing
sorting83221813_sorting
spooning112811443spooning
sporing104319413spor_ing
sporting112415463sporting
spurning11258663spurning
stoning83717443sto_ning
storing83921123stor_ing
storming11209423storming
storying12249673storying
swooning12278203swooning
swouning12246563swouning
tabering112211423taber_ing
tabooing11186313tabo_oing
taborin92210453tabor_in_
taborine102510683tabor_ine
taborins103310213tabor_ins
tabouring1245723tabouring
throning1238863throning
toning74025793_to_ning
turning83713183_turning
vaporing1437653vapor_ing
wagoning1336923wago_ning
warning113717093_warning
whoring142910293whor_ing
wonning113210793_wonning
wording123014563_wording
working153813253_working
worming132811243_worming
yarning113512953_yarning
yearning1296983yearning
zoning162914333_zo_ning
zooning172910703_zooning

Search took 10 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.1731032896.0
2DLD Change Limit1461622608.59317009.4
3Display Results2602600.2201181.8
 (SQL Overall)1786912608.98619885.5
 
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.