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

472 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
gratings10391076(None) 
gatings95212821g_atings
grating93923181grating_
gratins84119181gratin_s
grazings19337261grazings
ratings84217411_ratings
beatings114113232beatings
boatings113710112boatings
bracings13369292bracings
coatings113811842coatings
crating103725202crating_
cravings14428222cravings
draftings14334202draftings
drawings13386282drawings
eatings84616442_eatings
framings14338132framings
frayings15325992frayings
gamings114610912g_amings
gating84826952g_ating_
gearings10359502gearings
glazings19325752glazings
gnawings13263772gnawings
gracing113216442gracing_
gradines103615252gradines
grading103918712grading_
gradins93416232gradin_s
grafting13319622grafting_
grains74223092gra_in_s
granting103514522granting_
gratin74520582gratin__
gratine84719192gratin_e
gratinee93710782gratinee
gratinees10307312gratinees
gratingly1437392gratingly
gratis74819242grati__s
graving123114562graving_
graying124115882graying_
graylings1433882graylings
grazing183514552grazing_
greetings11276042greetings
gyrating1337452gyrating_
kartings13418522kartings
matings104516212_matings
orating83520322orating_
partings113513732partings
platings113611362platings
prating103424452prating_
racings105015132_racings
ratines75328582_ratines
rating74938702_rating_
ravings114614502_ravings
seatings93614302seatings
skatings13326992skatings
slatings94011722slatings
tracings112910412tracings
writings12298112writings
abating10413973abating_
actings104512463_actings
aerating92821003aerating_
agentings1134443agentings
agings86312673__agings
antings85015583_antings
arcadings1354393arcadings
archings14499863archings
armings103811503ar_mings
bakings144312023_bakings
bastings114214693bastings
bating95132253_bating_
battings114010573battings
beadings123711783beadings
bearings113912253bearings
beastings12387653beastings
beating104326873beating_
beltings11369253beltings
berating113220763berating_
bittings11339293bittings
bladings12337753bladings
blastings12347903blastings
boating103721303boating_
borating113414503borating_
bracing123817613bracing_
braidings13285903braidings
brains85125473bra_in_s
braking143917713braking_
brandings13277483brandings
braving133714613braving_
braying134416313braying_
brazing193715113brazing_
breakings16297063breakings
breathings16234313breathings
brewings14296693brewings
brings94618433br__ings
brokings15317713brokings
bruting102612993bruting_
buntings11348773buntings
cardings123812633cardings
carlings114015853carlings
carpings133812383carpings
carting104228283carting_
carvings143810203carvings
casings104013513_casings
castings113614053castings
catlings113712043_catlings
cavings134712543_cavings
ceratins102818733ceratin_s
chasings14318253chasings
coamings13349293coamings
coastings12357863coastings
coating103525313coating_
crackings18346843crackings
crafting143710173crafting_
craning103620303craning_
craping124018713craping_
craterings1346003craterings
cratons94316033craton_s
craving134015733craving_
crazing193914583crazing_
creatines112814433creatines
creating113921953creating_
creatins103617513creatin_s
crestings12298043crestings
cretins93216423cretin_s
curating11314293curating_
cuttings11277613cuttings
darings93713653_darings
darlings103710383darlings
darnings10378553darnings
darting94020663darting_
dating85326483_dating_
dealings103510703dealings
derating103222283derating_
dialings10329823dialings
doating93816863doating_
drafting13339403drafting_
drains73719403dra_in_s
draping114213353draping_
dratting10389653dratting_
drawing123812053drawing_
draying123813843draying_
drivings13265763drivings
ductings12346673ductings
dustings10419033dustings
earings84517713_earings
earnings9419333earnings
earrings9299633earrings
eastings93412953eastings
eating75134403_eating_
elating83423083elating_
emptings1364823emptings
engravings1542503engravings
erasing8317963erasing_
erlkings1333563erlkings
facings134511263_facings
fadings12469303_fadings
farmings14298223farmings
farthings1635233farthings
farting114120753farting_
fastings124011943fastings
fating105328673_fating_
fatlings12359303_fatlings
feltings12317903feltings
fittings12318203fittings
flatlings13315823flatlings
flutings12357373flutings
flytings15304793flytings
footings12248833footings
fraggings15324243fraggings
framing133014793framing_
fraying143413433fraying_
frostings1335733frostings
gaeing84617223g_aeing_
gaging94718403g_aging_
gains65729513g_a_in_s
gaiting93716583gaiting_
gamines103618463g_amines
gaming104622043g_aming_
gamins94420043g_amin_s
gangs76222573g_a__ngs
gaping105618923g_aping_
garaging1139043garaging_
garbing113613273garbing_
garoting10510703garoting_
garring93116713garring_
gaskings14427473gaskings
gassings10438403gassings
gasting95022763gasting_
gaywings1633193gaywings
gazing174717173g_azing_
gearing92818843gearing_
gelatines102910533gelatines
gelating103015733gelating_
gelatins93414093gelatin_s
geldings11316163geldings
getting93316563getting_
ghostings1433483ghostings
gifting123810893gifting_
gildings11356973gildings
ginnings10366523ginnings
girting93113333girting_
gitting93215703gitting_
glaring93714883glaring_
glazing183611003glazing_
gleanings11244643gleanings
gleyings13283653gleyings
gloamings13254093gloamings
gloating102611463gloating_
gnawing12377903gnawing_
goading103112853goading_
goaling93515333goaling_
godlings11367493godlings
goings84911523g__oings
golfings13304873golfings
goslings10297553goslings
grabbing14267313grabbing_
grabens10367003graben_s
graciles112511613graciles
gracilis11247033gracilis
gracious1138593gracious
gradating1237313gradating_
gradients1145273gradients
gradin83517483gradin__
gradine93317033gradin_e
grails77518783gra_i_ls
grain65126253gra_in__
grained93814273gra_ined
grainer83714063gra_iner
grainers93012073gra_iners
graining102813183graining_
grainy103914213gra_in_y
grands84218243gra__nds
grange83716203gra__nge
granges93516523gra__nges
granitas92610223granitas
granites92116363granites
grannies9312613grannies
grans64832543gra__n_s
grants73722473gra__nts
graphing1538533graphing_
grapiness1238243grapiness
graplines1237353graplines
graplins1148263graplin_s
grapplings1642323grapplings
grasping12348833grasping_
grassing103311973grassing_
graters85419743grat_ers
grates75429893grat__es
gratifies1347993gratifies
gratify1436113grati_fy
gratineed11334473gratineed
gravidas13285803gravidas
gravies11314093gravi_es
gravitas12316013gravitas
gravitinos1441963gravitinos
graylags1372983graylags
grayling1338003grayling_
graziers18387123graziers
grazingly2344943grazingly
greasing102811393greasing_
greatens9307593greaten_s
greeing93613783greeing_
greenings11266663greenings
greeting103112353greeting_
greying124110893greying_
griding103014973griding_
grifting13299263grifting_
grigs75318193gr__i_gs
griming113612493griming_
grinds84511843gr__inds
gringa838553gr__inga
gringas938043gr__ingas
gringo838643gr__ingo
gringos936673gr__ingos
grins65427223gr__in_s
griping113012063griping_
gritting10309983gritting_
groaning102410283groaning_
groins73917203gr_oin_s
groping113313103groping_
groupings13273813groupings
grouting103410793grouting_
growing123512473growing_
gruelings1163763gruelings
grunting10269583grunting_
guanines989773guanines
guanins8810013guanin_s
gunnings10346733gunnings
gusting93917163gusting_
gutting93415923gutting_
gyrations1336923gyrations
harpings14379773harpings
hating104929713_hating_
hayings14379393_hayings
hazings20378343_hazings
headings133510493headings
hearings123611853hearings
heating114024323heating_
huntings12328053huntings
hustings12378683hustings
imagings1234553imagings
ironings9217583ironings
isatines8310663isatines
isatins7310773isatin_s
jestings16368023jestings
jottings16275193jottings
karting123716063karting_
keratins122313483keratin_s
kiltings13327083kiltings
lacings105013653_lacings
ladings93814133_ladings
lakings124713513_lakings
lastings94214423lastings
lathings12469853_lathings
latinas74416463_latinas
latinos73613803_latinos
lawings113611473_lawings
leadings103511243leadings
leanings94010183leanings
leasings9379843leasings
leavings12407493leavings
listings93310043listings
loadings10378383loadings
loanings9348013loanings
loathings1344213loathings
lutings83311053_lutings
makings145413163_makings
markings153410243markings
marlings113713493marlings
marting103325013marting_
martinis103311613martinis
martins93322063martin_s
mating94832913_mating_
matins84527783_matin_s
mattings11369673mattings
mayings134410513_mayings
meanings11329163meanings
meetings11287413meetings
migrating13910533migrating_
moating104218153moating_
muntings11289813muntings
nettings9288103nettings
nuttings9276783nuttings
orangs74116033ora__ngs
orations81515803orations
outings84014753_outings
pagings114411063_pagings
palings103915823_palings
parawings1535823parawings
pargings123410163pargings
parings104219213_parings
parkings153610683parkings
parting103527383parting_
patinas96318523_patinas
patines95225763_patines
patins87528783_patin_s
pavings134011633_pavings
pettings11349703pettings
phrasings1544333phrasings
pirating11314513pirating_
pittings11349123pittings
plaitings12296243plaitings
plantings12348403plantings
platinas103610313platinas
plating103823073plating_
postings112912303postings
pralines102217723pralines
prangs94816233pra__ngs
pratingly1538363pratingly
praying133717323praying_
primings13338143primings
printings12268103printings
racing95030533_racing_
rafting113815753_rafting_
raging85126433_raging_
railings93412153_railings
rains55140233_ra_in_s
raisings9338443_raisings
raking114728423_raking_
rankings13389173_rankings
ranting84025413_ranting_
rapines95120863_rapines
raping94829853_raping_
raring74332873_raring_
rasing74330833_rasing_
raspings11337853_raspings
ratans63819373_ratan_s
ratbags1035763_ratbags
ratfinks1542853_ratfinks
ratine65131823_ratin_e
rations74123433_rations
ratios64922673_rati_os
ratites74920683_ratites
ratlines83815293_ratlines
ratlins73615583_ratlin_s
ratting83822363_ratting_
rattlings10235513_rattlings
ravines104220233_ravines
raving105128853_raving_
ravins94622563_ravin_s
rawins95617623_rawin_s
raxing144321023_raxing_
raying105027193_raying_
razing164524543_razing_
readings103512643readings
regrating111316213regrating_
retinas74819353_retinas
retines75134673_retines
retints74717013_retints
ridings93412093_ridings
rings65029173_r__ings
risings83211893_risings
roarings9248293roarings
rovings11439493_rovings
rowings113710363_rowings
rulings83310383_rulings
rutins63818393_rutin_s
saltings92811253saltings
satangs8479713_satangs
sating74735453_sating_
satins64930483_satin_s
savings114412953_savings
sayings113610833_sayings
scrapings14255173scrapings
seating84130683seating_
settings93810073settings
shadings13327433shadings
shaftings16224183shaftings
shavings15356333shavings
siftings12236583siftings
sittings9339733sittings
skating123613843skating_
slating83724653slating_
slattings10346073slattings
soarings93210393soarings
spacings13287043spacings
spaeings11276253spaeings
stagings10378343stagings
stating83725163stating_
statins73719773statin_s
stings76220183__stings
suitings9288953suitings
takings124512573_takings
tarting84222653tarting_
tattings9408823tattings
tings65329203___tings
tintings9288713tintings
tracing103720153tracing_
trackings16247543trackings
trading93517973trading_
trainings10246723trainings
trains64725343tra_in_s
trappings14265753trappings
treating92519613treating_
trithings13246603trithings
tuftings12264323tuftings
uprating11311113uprating_
vestings12359143vestings
waitings123413743waitings
warnings12358453warnings
waxings18366453_waxings
weltings12388203weltings
westings12429803westings
wettings12348403wettings
whalings15256763whalings
whitings15287063whitings
wittings12328733wittings
wrangs104611913wra__ngs
wrappings17253713wrappings
wrathing15248923wrathing_
wrings104012973wr__ings
writing113713893writing_
yealings12257703yealings
zeatins16311733zeatin_s

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.186960704.3
2DLD Change Limit1461624728.25317710.2
3Display Results4724720.1862537.6
 (SQL Overall)1786914728.62520717.8
 
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.