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

424 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
earrings929963(None) 
earings84517711ea_rings
earnings9419331earnings
earring83519011earring_
airings83913842_airings
armings103811502_armings
barring104021592barring_
bearings113912252bea_rings
cardings123812632cardings
carlings114015852carlings
carpings133812382carpings
carvings143810202carvings
darings93713652da_rings
darlings103710382darlings
darnings10378552darnings
eanlings9128472eanlings
earing75235482ea_ring_
earning83418212earning_
earringed1144452earringed
earwigs11104412earwi_gs
eastings93412952eastings
eatings84616442ea_tings
erring73816482e_rring_
fairings12388192fairings
farmings14298222farmings
furrings12317142furrings
garring93116712garring_
gearings10359502gea_rings
harpings14379772harpings
hearings123611852hea_rings
herrings12379532herrings
jarring153613192jarring_
kartings13418522kartings
learnings1094322learnings
markings153410242markings
marlings113713492marlings
marring103319552marring_
pairings11398312pairings
pargings123410162pargings
parings104219212pa_rings
parkings153610682parkings
parring103222062parring_
partings113513732partings
sacrings11278922sacrings
tarring83318302tarring_
warnings12358452warnings
warring113717972warring_
yearlings1384202yearlings
yearnings1393552yearnings
ablings1038743_ablings
actings104512463_actings
ageings9437693_ageings
agings86312673_a_gings
airing74927503_airing_
antings85015583_antings
archings14499863_archings
arcing95819643_arcing_
arming94719803_arming_
aroints7313133_aroints
arraigns944353_arraigns
arrange838683_arrange
arranges939413_arranges
arris56824683_arri__s
arrises71617583_arrises
arrives101311513_arrives
arsines73518813_arsines
askings12519173_askings
audings9289393_audings
awnings11406713_awnings
backings174012213backings
baggings13307523baggings
bakings144312023ba_kings
bankings15489403bankings
barbing123716993barbing_
barding113822893barding_
barfing134615093barfing_
barging114018483barging_
baring95135853ba_ring_
barking144724183barking_
barning104320353barning_
barongs105310833ba_rongs
barrens94414323barren_s
barriers104311883barriers
barrios9310773barri_os
bashings144311243bashings
bastings114214693bastings
battings114010573battings
beadings123711783bea_dings
bearding124011943bearding_
bearing103624773bea_ring_
beastings12387653beastings
beatings114113233bea_tings
birdings12378823birdings
birlings11359613birlings
birring103713063birring_
boardings13296063boardings
borings103614243_borings
bracings13369293bracings
brings94618433__brings
burnings11387623burnings
burring104016993burring_
calkings15289223calkings
callings113613833callings
campings154010203campings
cannings113710333cannings
cappings15369493cappings
carbines123617533carbines
carding113922433carding_
carinas93622403ca_rinas
caring95137993ca_ring_
carking144322853carking_
carlines103521643carlines
carling103727063carling_
carlins93921913carlin_s
carmines123617863carmines
carping123521083carping_
carriage1137853carriage
carriages1238333carriages
carriers103614203carriers
carries94328013carri_es
carrions10312453carrions
carrying14148373carrying_
carting104228283carting_
carving133916773carving_
casings104013513ca_sings
castings113614053castings
catlings113712043catlings
cavings134712543ca_vings
centrings12227603centrings
charring142913163charring_
clearings12286063clea_rings
clearwings1651703clearwings
cordings123011353cordings
cravings14428223cravings
curbings13407313curbings
curlings114110383curlings
curring103616843curring_
dairyings1442633dairyings
dampings14377523dampings
daring84928683da_ring_
darking134217343darking_
darklings1533983darklings
darling93418363darling_
darning93817333darning_
darting94020663darting_
deairing10311893deairing_
dealings103510703dea_lings
debarring1335713debarring_
drawings13386283drawings
eagling91113603eagling_
eanling81416673eanling_
earliness939693earliness
earns55927563ea_r_n_s
earplugs1142243earplugs
earthing12310323earthing_
earthlings1443613earthlings
earwig10114703earwi_g_
easing74926463ea_sing_
easting84924303easting_
eating75134403ea_ting_
edgings10256243e_dgings
embarring1444513embarring_
emptings1364823emptings
endings92910443e_ndings
endrins8312163endrin_s
enuring8813883enuring_
erasing8317963erasing_
eringo739553e__ringo
eringos836913e__ringos
erlkings1333563erlkings
ermines9416673e_rmines
errands847603e_rrands
errants7410643e_rrants
errhines1136413errhines
erringly1237773e_rringly
eserines8413743eserines
estrins7315853estrin_s
etchings14396293etchings
evenings1234383evenings
facings134511263fa_cings
fadings12469303fa_dings
failings123811013failings
fairing113614013fairing_
farcing133514003farcing_
farding123716743farding_
farinas103215233fa_rinas
faring105231283fa_ring_
farming133515083farming_
farriers113610743farriers
farthings1635233farthings
farting114120753farting_
fastings124011943fastings
fatlings12359303fatlings
fearing113520033fea_ring_
firings114112333_firings
forgings13287703forgings
framings14338133framings
frayings15325993frayings
furring114013143furring_
gamings114610913ga_mings
garbing113613273garbing_
garrons82713463garron_s
gaskings14427473gaskings
gassings10438403gassings
gatings95212823ga_tings
gaywings1633193gaywings
gearing92818843gea_ring_
gnarring10225973gnarring_
gratings103910763gratings
grazings19337263grazings
hangings13258583hangings
haring104233003ha_ring_
harking154120943harking_
harmines132715143harmines
harming133717933harming_
harmins123716723harmin_s
harping134118383harping_
harpins123615703harpin_s
harriers113712433harriers
harries103525493harri_es
harrying15157643harrying_
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
headings133510493hea_dings
hearing113324163hea_ring_
hearsing1239383hearsing_
hearting12513123hearting_
herring113615883herring_
hoardings14315113hoardings
hornings12238363hornings
hurlings12388213hurlings
jarinas143712183ja_rinas
jarringly2045193jarringly
karting123716063karting_
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lairing83715343lairing_
lakings124713513la_kings
landings103110073landings
lapwings14274973lapwings
larding92917873larding_
larking123718253larking_
lashings124412253lashings
lastings94214423lastings
lathings12469853lathings
latrines8515003latrines
lawings113611473la_wings
layerings13235683layerings
leadings103511243lea_dings
leanings94010183lea_nings
learning978553learning_
leasings9379843lea_sings
leavings12407493lea_vings
lordings10368503lordings
mailings113011923mailings
makings145413163ma_kings
mallings113413093mallings
mappings15296413mappings
marblings14225543marblings
margins103815193margin_s
marinas93519383ma_rinas
marines93928013ma_rines
marking144020133marking_
marlines103818713marlines
marling103322763marling_
marlins93420473marlin_s
marranos1038423marranos
marriage1147253marriage
marriages1247383marriages
marrieds11288073marrieds
marriers103312473marriers
marries93825283marri_es
marrons93216973marron_s
marrying14157223marrying_
marting103325013marting_
martinis103311613martinis
martins93322063martin_s
maskings15448753maskings
matings104516213ma_tings
mattings11369673mattings
mayings134410513ma_yings
meanings11329163mea_nings
moorings11257713moorings
mornings11297923mornings
narking124015383narking_
nearing83020333nea_ring_
nervings12256313nervings
nursings9325773nursings
oaring74225303oa_ring_
outrings92811053outrings
packings174310063packings
paddings13297013paddings
pagings114411063pa_gings
pairing103716733pairing_
palings103915823pa_lings
parangs104314373pa_rangs
parawings1535823parawings
parging113318603parging_
paring94236493pa_ring_
parking143423043parking_
parling103823763parling_
parridge1254333parridge
parridges1384553parridges
parriers103612903parriers
parries93925843parri_es
parrying14168133parrying_
parsing103819553parsing_
parting103527383parting_
passings11409873passings
pavings134011633pa_vings
pearling11912013pearling_
pharmings17254723pharmings
purgings12347293purgings
purlings113910283purlings
purring104515823purring_
quarryings2371763quarryings
racings105015133ra_cings
railings93412153railings
raisings9338443raisings
rankings13389173rankings
raring74332873ra_ring_
raspings11337853raspings
ratings84217413ra_tings
ravings114614503ra_vings
readings103512643rea_dings
rearing83128783rea_ring_
rearming111413613rearming_
rearrange1045033rearrange
rearranges1145113rearranges
resprings12156253resprings
restrings10159293restrings
rings65029173___rings
roarings9248293roarings
sabring102614843sabring_
sackings15389633sackings
sacring103115983sacring_
sailings93513253sailings
saltings92811253saltings
saplings11269803saplings
sarcinas1039273sarcinas
sardines92815563sardines
sarins63932623sa_rin_s
sarongs84511803sa_rongs
savings114412953sa_vings
sayings113610833sa_yings
scarring112511513scarring_
seafarings1442783seafarings
searing83330923sea_ring_
seatings93614303sea_tings
sergings10299213sergings
servings12249223servings
shearings13337563shea_rings
shearlings1443533shearlings
shirrings13245323shirrings
shorings12269483shorings
soarings93210393soarings
sorings83817253_sorings
sparlings12257153sparlings
sparring113112223sparring_
springs104415923_springs
starlings10237923starlings
starring92312953starring_
stirrings10224693stirrings
strings84617133_strings
subrings11229883subrings
surfings12268073surfings
tacrines10310563tacrines
tailings93211673tailings
takings124512573ta_kings
talkings13358403talkings
tannings9268633tannings
tappings13267713tappings
taring73932283ta_ring_
tarriers83411713tarriers
tarries73324263tarri_es
tarriness9229243tarriness
tarrying12146723tarrying_
tarting84222653tarting_
tattings9408823tattings
taurines8310553taurines
teachings15296553teachings
tearing84021493tea_ring_
terrines82117553terrines
tourings9277373tourings
tracings112910413tracings
turnings9287233turnings
vaporings1544093vaporings
varmints1335643varmints
varying1429723varying_
waddings14356473waddings
wairing113414313wairing_
waitings123413743waitings
walkings16327313walkings
warding123918143warding_
waring105029443wa_ring_
warking153519573warking_
warming133515083warming_
warning113717093warning_
warping133715183warping_
warrants1168503warrants
warrens103810893warren_s
warriors1135363warriors
washings15419273washings
waterings13229253waterings
waxings18366453wa_xings
waxwings2232953waxwings
weaklings1794003weaklings
weanlings1394413weanlings
wearing113318863wea_ring_
wearying1546703wearying_
wirings113910113_wirings
wordings13328563wordings
workings16337503workings
wrings104012973__wrings
yarding123413143yarding_
yarning113512953yarning_
yawpings17253583yawpings
yealings12257703yea_lings
yeanlings1393693yeanlings
yearling1297883yearling_
yearning1296983yearning_
yirring11307763yirring_

Search took 9 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.1561145455.1
2DLD Change Limit1461624248.31317582.3
3Display Results4244240.1702494.1
 (SQL Overall)1786914248.63920684.2
 
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.