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

440 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
drafting1333940(None) 
crafting143710171crafting
draftings14334201draftings
dratting10389651dratting
drifting13338731drifting
grafting13319621grafting
rafting113815751_rafting
crating103725202cra_ting
daffing15369732d_affing
darting94020662d_arting
dating85326482d_a_ting
dauting93814762d_auting
dawting123610672d_awting
derating103222282dera_ting
deratting1139512deratting
doating93816862doa_ting
drabbing14286802drabbing
draftier1285262draftier
draftily1534412draftily
dragging12308102dragging
draining103312672draining
dramming14347562dramming
draping114213352dra_ping
drawing123812052dra_wing
drawling13318672drawling
draying123813842dra_ying
granting103514522granting
grating93923182gra_ting
grifting13299262grifting
hafting144014172_hafting
orating83520322ora_ting
prating103424452pra_ting
ranting84025412_ranting
rating74938702_ra_ting
ratting83822362_ratting
redrafting1545962redrafting
rifting113515002_rifting
shafting15278672shafting
wafting143911662_wafting
abating10413973aba_ting
acting95920983__acting
adapting1236643adapting
aerating92821003aera_ting
anting75827023__anting
awaiting1238273awaiting
baffing164011603_baffing
baiting103918883_baiting
barfing134615093barf_ing
basting104227203_basting
bating95132253_ba_ting
batting104422273_batting
beating104326873bea_ting
berating113220763bera_ting
blasting114013423blasting
blatting114111653blatting
boasting113512493boasting
boating103721303boa_ting
borating113414503bora_ting
bracing123817613bra_cing
bradding13268933bradding
bragging13359333bragging
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
braking143917713bra_king
branding122513683branding
branning112911093branning
brassing112612303brassing
brattling1236003brattling
braving133714613bra_ving
bravoing1445993bravoing
brawling143210043brawling
braying134416313bra_ying
brazing193715113bra_zing
breasting1239583breasting
bruiting11259973bruiting
bruting102612993br_uting
canting104725903_canting
carting104228283_carting
casting104628343_casting
catting103922643_catting
chaffing2036323chaffing
chafing163911493chaf_ing
chanting143413533chanting
charting142614193charting
chatting142810143chatting
clefting14347583clefting
coacting133412703coacting
coapting133511613coapting
coasting113615513coasting
coating103525313coa_ting
craaling112711353craaling
crabbing15287933crabbing
cracking174013903cracking
cradling122411453cradling
craftier1376193craftier
craftily1644783craftily
cramming15339433cramming
cramping153411853cramping
craning103620303cra_ning
cranking154613073cranking
craping124018713cra_ping
crapping153911453crapping
crashing143512633crashing
craving134015733cra_ving
crawling143110513crawling
crazing193914583cra_zing
creating113921953creating
cresting114017043cresting
crusting113612793crusting
curating11314293cura_ting
dabbing133511233d_abbing
dadoing1038523d_adoing
damming133812743d_amming
damning114211633d_amning
damping133414003d_amping
dancing113611563d_ancing
danging103716093d_anging
dapping133714793d_apping
daring84928683d_a_ring
darking134217343d_arking
darkling1437483darkling
darling93418363d_arling
darning93817333d_arning
dartling1039563dartling
dashing125917893d_ashing
daubing11358623d_aubing
daunting103310403daunting
dawing114819823d_a_wing
dawning124111013d_awning
dazing175516513d_a_zing
deafening1476273deafening
deairing10311893deairing
dealing94323233dea_ling
deaning94020473dea_ning
deashing134210953deashing
deaving123814753dea_ving
debating123213733debating
debiting122511203debiting
debuting12268633debuting
decanting132510633decanting
defacing15238683defacing
defaming15238463defaming
defatting1436103defatting
defying15328823d_efying
deifying1637633deifying
delating103119603delating
deleting103314423deleting
demasting1338453demasting
demoting12311423demoting
denoting10311753denoting
denting94422183d_enting
departing1349513departing
deputing12238793deputing
derailing112011313derailing
deranging1238063deranging
desalting1138843desalting
detracting1438713detracting
devoting1338823devoting
dialing94318173dia_ling
dialling10310783dialling
dieting93616833d_ieting
dighting142510843dighting
dilating102714903dilating
diluting10248983diluting
dinting93520553d_inting
directing1338813directing
disrating11714553disra_ting
doffing15357793d_offing
donating10311803donating
doting84821913d__oting
dotting93314483d_otting
doubting1237373doubting
drabbling1544553drabbling
draffier1574323draffier
draffish1844553draffish
draft95526683draft___
drafted12439033draft_ed
draftee11379523draft_ee
draftees12225253draftees
drafter11449423draft_er
drafters12338523drafters
draftiest1335943draftiest
draftiness1444853draftiness
drafts105012533draft__s
drafty13638933draft__y
draggling1354613draggling
dragline1036843dragline
drain65222893dra__in_
drains73719403dra__ins
drastic10310873drasti_c
draughting1642883draughting
drawings13386283dra_wings
drawstring1542063drawstring
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
dribbing14325883dribbing
driftier1275123driftier
driftingly1843663driftingly
driftpin1441843driftpin_
driftpins1541833driftpins
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dr_iving
drolling103510763drolling
droning93013723dr_oning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
drying113411603dr__ying
ducting113713593d_ucting
dueting93814393d_ueting
duetting1047183duetting
dunting93418383d_unting
dusting93618993d_usting
dwarfing1633613dwarfing
easting84924303_easting
eating75134403_ea_ting
elating83423083ela_ting
enacting11311363enacting
engrafting1544183engrafting
erasing8317963era_sing
erecting112415063erecting
eructing112110173eructing
erupting11218443erupting
exacting1838523exacting
exalting1638033exalting
farting114120753_farting
fasting114522833_fasting
fating105328673_fa_ting
fatting113818703_fatting
feasting122011323feasting
flatting123511253flatting
fragging14329423fragging
framing133014793fra_ming
franking164310863franking
frapping16348103frapping
fraying143413433fra_ying
fretting122711523fretting
fritting123510703fritting
fronting12310443fronting
frosting12311183frosting
fruiting12229063fruiting
gaffing15379733_gaffing
gaiting93716583_gaiting
garoting10510703garoting
gasting95022763_gasting
gating84826953_ga_ting
gifting123810893_gifting
grabbing14267313grabbing
gracing113216443gra_cing
gradating1237313gradating
grading103918713gra_ding
graffiting1842923graffiting
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
gratin74520583gra_tin_
gratine84719193gra_tine
gratings103910763gra_tings
gratins84119183gra_tins
graving123114563gra_ving
graying124115883gra_ying
grayling1338003grayling
grazing183514553gra_zing
greeting103112353greeting
gritting10309983gritting
grouting103410793grouting
gruffing1635273gruffing
grunting10269583grunting
gyrating1337453gyra_ting
halting114419073_halting
hanting114124483_hanting
hasting114725193_hasting
hating104929713_ha_ting
hatting113920233_hatting
hearting12513123hearting
heating114024323hea_ting
hefting144510913_hefting
hydrating1746323hydra_ting
ideating10311703idea_ting
ingrafting1544893ingrafting
karting123716063_karting
kraaling13186663kraaling
lasting84725243_lasting
leafing113313583leaf_ing
lifting113313273_lifting
loafing11319793loaf_ing
lofting113311313_lofting
malting103219083_malting
marting103325013_marting
masting104325823_masting
mating94832913_ma_ting
matting103620143_matting
moating104218153moa_ting
naffing14359033_naffing
orbiting1138153orbiting
panting104025423_panting
parting103527383_parting
pasting103826553_pasting
patting103722343_patting
piaffing1733923piaffing
pirating11314513pira_ting
plaiting113113513plaiting
planting113515383planting
plating103823073pla_ting
platting114813033platting
praising113214563praising
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prattling1246303prattling
prawning1446963prawning
praying133717323pra_ying
preacting142412533preacting
printing113216083printing
profiting1549983profiting
quaffing2434353quaffing
quanting1849233quanting
racing95030533_ra_cing
racking144323663_racking
radding103715003_radding
raffling1567063_raffling
ragging103516683_ragging
raging85126433_ra_ging
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
raking114728423_ra_king
ramming123115063_ramming
ramping123316873_ramping
ranging94120263_ranging
ranking124320883_ranking
raping94829853_ra_ping
rapping123619103_rapping
raring74332873_ra_ring
rasing74330833_ra_sing
rasping104316253_rasping
ratfink1434943_ratfink
ratine65131823_ra_tine
ratings84217413_ra_tings
rattling92510873_rattling
raving105128853_ra_ving
raxing144321023_ra_xing
raying105027193_ra_ying
razing164524543_ra_zing
razzing1636323_razzing
reacting113317893reacting
reffing143712173_reffing
refuting121911903_refuting
regrafting1545993regrafting
renting84026853_renting
resting85031183_resting
retting83425883_retting
riffing144011273_riffing
rifling112815013_rifling
rioting82716393_rioting
roasting93012693roasting
rooting83522433_rooting
rotting82919683_rotting
routing83821093_routing
ruffing143210843_ruffing
rusting83821263_rusting
rutting82718043_rutting
salting84120793_salting
sating74735453_sa_ting
scanting113914763scanting
scarting113415263scarting
scatting113311813scatting
seating84130683sea_ting
shaftings16224183shaftings
shifting152910373shifting
sifting113014593_sifting
skating123613843ska_ting
slanting94115093slanting
slating83724653sla_ting
slatting94014233slatting
smarting113212453smarting
snafuing1235083snafuing
spatting113111763spatting
staffing15247493staffing
starting93116173starting
stating83725163sta_ting
strafing122111193straf_ing
swatting12309593swatting
tarting84222653_tarting
tasting84624213_tasting
tatting84019523_tatting
tauting83316383_tauting
toasting93410573toasting
tracing103720153tra_cing
tracking153715463tracking
trading93517973tra_ding
traiking132511973traiking
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trawling122710783trawling
treating92519613treating
trifling122411503trifling
trotting92510913trotting
truanting1035603truanting
trusting93411653trusting
trysting12267053trysting
tufting11289873_tufting
uprating11311113upra_ting
upwafting1842063upwafting
vatting113614853_vatting
waffing173710243_waffing
waiting113618953_waiting
wanting114220173_wanting
wasting114422843_wasting
wracking18349963wracking
wrapping16297623wrapping
wrastling1335523wrastling
wrathing15248923wrathing
wresting123811833wresting
writing113713893wr_iting
yaffing17337823_yaffing
yeasting12188923yeasting
zaftig1933253_zafti_g

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 Limit1461624408.82616560.4
3Display Results4404400.1862365.6
 (SQL Overall)1786914409.18519454.7
 
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.