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

507 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
shafting1527867(None) 
hafting144014171_hafting
shaftings16224181shaftings
shifting152910371shifting
chaffing2036322chaffing
chafing163911492chaf_ing
chanting143413532chanting
charting142614192charting
chatting142810142chatting
crafting143710172crafting
drafting13339402drafting
grafting13319622grafting
halting114419072_halting
hanting114124482_hanting
hasting114725192_hasting
hating104929712_ha_ting
hatting113920232_hatting
hefting144510912_hefting
rafting113815752_rafting
salting84120792s_alting
sating74735452s_a_ting
scanting113914762scanting
scarting113415262scarting
scatting113311812scatting
seating84130682sea_ting
shacking184014082shacking
shading123115562sha_ding
shagging14349052shagging
shaking153317252sha_king
shaming133016742sha_ming
shamming16289412shamming
shanking163612282shanking
shantung1232732shantung
shaping133116182sha_ping
sharing113723242sha_ring
sharking163912972sharking
sharping143011372sharping
shauling1249392shauling
shaving143414332sha_ving
shawing143514882sha_wing
shawling1558222shawling
sheafing15329482sheaf_ing
sheeting122712822sheeting
shirting123213602shirting
shitting123212652shitting
shooting122812842shooting
shorting122514792shorting
shotting123012362shotting
shouting122711782shouting
shunting123610422shunting
shuting113212042sh_uting
shutting12309682shutting
sifting113014592s_ifting
skating123613842ska_ting
slanting94115092slanting
slating83724652sla_ting
slatting94014232slatting
smarting113212452smarting
snafuing1235082snafuing
spatting113111762spatting
staffing15247492staffing
starting93116172starting
stating83725162sta_ting
swatting12309592swatting
wafting143911662_wafting
abating10413973aba_ting
acting95920983__acting
adapting1236643adapting
anting75827023__anting
asphalting1643383asphalting
awaiting1238273awaiting
baffing164011603_baffing
baiting103918883_baiting
basting104227203_basting
bating95132253_ba_ting
batting104422273_batting
beating104326873bea_ting
blasting114013423blasting
blatting114111653blatting
boasting113512493boasting
boating103721303boa_ting
canting104725903_canting
carting104228283_carting
casting104628343_casting
catting103922643_catting
chaining142810783chaining
chairing143110773chairing
chalking183310063chalking
champing183610933champing
chancing162810283chancing
changing153211513changing
chapping183710723chapping
charging152910773charging
charing133721323cha_ring
charking183512613charking
charming163012023charming
charring142913163charring
chasing133715893cha_sing
chaunting1555413chaunting
chawing164813033cha_wing
cheating144014523cheating
cheffing2034463cheffing
chefing16359033chef_ing
chuffing2055043chuffing
chuting132910733ch_uting
clefting14347583clefting
coacting133412693coacting
coapting133511603coapting
coasting113615503coasting
coating103525303coa_ting
crating103725203cra_ting
daffing15369733_daffing
darting94020663_darting
dating85326483_da_ting
dauting93814763_dauting
dawting123610673_dawting
doating93816863doa_ting
draftings14334203draftings
dratting10389653dratting
drifting13338733drifting
easting84924303_easting
eating75134403_ea_ting
elating83423083ela_ting
enacting11311363enacting
estating92614993esta_ting
exacting1838523exacting
exalting1638033exalting
farting114120753_farting
fasting114522833_fasting
fating105328673_fa_ting
fatting113818703_fatting
feasting122011323feasting
flatting123511253flatting
gaffing15379733_gaffing
gaiting93716583_gaiting
gasting95022763_gasting
gating84826953_ga_ting
ghosting1336463ghosting
gifting123810893_gifting
granting103514523granting
grating93923183gra_ting
grifting13299263grifting
habiting1437533_habiting
hacking173720613_hacking
hading113922943_ha_ding
haeing104118923_ha_eing
hagging133114683_hagging
hailing113820693_hailing
haling104229783_ha_ling
haloing113814133_haloing
halving143511543_halving
hamming153014093_hamming
handing123518893_handing
hanging123518703_hanging
hanking154619103_hanking
happing153817233_happing
haring104233003_ha_ring
harking154120943_harking
harming133717933_harming
harping134118383_harping
hashing145020163_hashing
hasping134414903_hasping
hauling113714433_hauling
haunting123510053_haunting
having134220373_ha_ving
hawing134322353_ha_wing
hawking183711423_hawking
haying134420613_ha_ying
hazing194218553_ha_zing
hearting12513123hearting
heating114024323_heating
henting113719653_henting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hitting113017273_hitting
hooting113919873_hooting
hosting114318383_hosting
hotting113116513_hotting
huffing17278833_huffing
hunting114317123_hunting
hurting113914033_hurting
hutting113016033_hutting
karting123716063_karting
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
orating83520323ora_ting
panting104025423_panting
parting103527383_parting
pasting103826553_pasting
patting103722343_patting
pharming16248143pharming
phasing133211673pha_sing
piaffing1733923piaffing
plaiting113113513plaiting
planting113515383planting
plating103823073pla_ting
platting114813033platting
prating103424453pra_ting
pshawing1733523psha_wing
quaffing2434353quaffing
quanting1849233quanting
ranting84025413_ranting
rating74938703_ra_ting
ratting83822363_ratting
reacting113317893reacting
rifting113515003_rifting
roasting93012693roasting
sabbing123314743s_abbing
sabeing102611863s_abeing
sabring102614843s_abring
sacking144122703s_acking
sacring103115983s_acring
safetying1643073s_afetying
sagging103116103s_agging
sailing83927373s_ailing
saining83621393s_aining
sainting93215733sainting
saltine75018563s_altine
saltings92811253s_altings
saluting9310553saluting
salving113913153s_alving
sanding93520603s_anding
saning75127643s_a_ning
sapling103217863s_apling
sapping123519313s_apping
sashing114621473s_ashing
sassing84615553s_assing
satang75711563s_a_tang
satin55935213s_a_tin_
satins64930483s_a_tins
satiny93817983s_a_tiny
saucing10311003s_aucing
sauteing937913s_auteing
saving104724513s_a_ving
sawing104323813s_a_wing
saying104325543s_a_ying
scabbing15277193scabbing
scalding12339393scalding
scaling103519373sca_ling
scalping133410453scalping
scamming15328543scamming
scamping153510193scamping
scanning113310773scanning
scantling12107233scantling
scaping123715693sca_ping
scarfing14309713scarfing
scaring103421973sca_ring
scarping133312463scarping
scarring112511513scarring
scathing14269703scathing
scenting113212813scenting
sclaffing1843363sclaffing
scoffing17275943scoffing
scooting113012633scooting
scouting112612753scouting
scuffing17287113scuffing
seafaring1345963seafaring
seagoing1038193seagoing
sealifting1444633sealifting
sealing83528563sea_ling
seaming103222113sea_ming
searing83330923sea_ring
seatings93614293sea_tings
sedating103014113sedating
selfing112911623self_ing
setting83621393s_etting
shackling19286173shackling
shadings13327433sha_dings
shadowing1744263shadowing
shaft115725253shaft___
shafted14288803shaft_ed
shafts125411433shaft__s
shaitan1036883shaitan_
shaitans1136403shaitans
shambling1735593shambling
shammying2042953shammying
shamoying1844523shamoying
shanti94014073shanti__
shanties113116573shanties
shantih13309613shanti_h
shantihs14276203shantihs
shantis103313083shanti_s
shantungs1341653shantungs
shattering1498283shattering
shaveling1646843shaveling
shavings15356333sha_vings
shealing123415463shealing
shearing123915903shearing
shearling1336923shearling
sheathing1636863sheathing
sheaving154110253sheaving
shedding14278113shedding
sheening123010803sheening
sheering123715103sheering
sheetings13256713sheetings
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shewing143812193sh_ewing
shieling123512403shieling
shiftier1436333shiftier
shiftily1744543shiftily
shilling123315373shilling
shimming16278253shimming
shining113816523sh_ining
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirring122910443shirring
shirtings13276603shirtings
shoaling123111743shoaling
shocking184311533shocking
shoeing113211873sh_oeing
shogging14308013shogging
shooing112112903sh_ooing
shooling123012553shooling
shootings13266053shootings
shopping163611283shopping
shoring112820063sh_oring
shoving142910633sh_oving
showing143814653sh_owing
showring1548313showring
shrewing15228083shrewing
shrining122610853shrining
shriving15268453shriving
shroffing1943303shroffing
shucking18339433shucking
shuffling1933443shuffling
shunning12367843shunning
shushing15317743shushing
shuttling1334283shuttling
shying134211843sh__ying
siftings12236583s_iftings
sighting133110863sighting
silting83320483s_ilting
siting74126623s__iting
sitting83519633s_itting
skanking12288743skanking
skatings13326993ska_tings
skirting13289393skirting
skiting123812493s_kiting
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slamming133310003slamming
slanging103413433slanging
slapping133510833slapping
slashing123713413slashing
slatings94011723sla_tings
slattings10346073slattings
slaving113514833sla_ving
slaying113316843sla_ying
sleeting93114163sleeting
slitting93012583slitting
slotting92612603slotting
sluffing15247303sluffing
smacking173510763smacking
smaltine1037833smaltine
smashing143310243smashing
smelting11339713smelting
smiting103014443s_miting
smutting11278063smutting
snacking153411703snacking
snaffling1643753snaffling
snagging11319373snagging
snailing92912973snailing
snaking123915303sna_king
snapping13349653snapping
snarfing12358663snarfing
snaring83920953sna_ring
snarling92513183snarling
snawing113612483sna_wing
sniffing15227453sniffing
snooting92813193snooting
snorting92613373snorting
snouting92511923snouting
snuffing15256793snuffing
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
solating9315593solating
sooting82820953s_ooting
sopiting11310763sopiting
sorting83221813s_orting
spacing123614493spa_cing
spading113114383spa_ding
spaeing103413543spa_eing
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparing104823873spa_ring
sparking152812533sparking
sparling112714523sparling
sparring113112223sparring
spartina1037983spartina
spasming13227203spasming
spawning14296913spawning
spaying133014623spa_ying
spiffing17237083spiffing
spirting112913633spirting
spiting103917623s_piting
spitting113012323spitting
splatting1235983splatting
sporting112415463sporting
spotting112812083spotting
spouting113511953spouting
spurting113111633spurting
squatting1934513squatting
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
stagging113310513stagging
staging93818373sta_ging
staining9413373staining
staking123919803sta_king
staling83925423sta_ling
stalking133512223stalking
stalling95116693stalling
stamping133310963stamping
standing103413633standing
stanging104013653stanging
staning83922243sta_ning
stapling112813153stapling
staring84527053sta_ring
starling93017123starling
starring92312953starring
startling1037373startling
starving122510173starving
stashing123511583stashing
statin63921463sta_tin_
statins73719773sta_tins
staving113915703sta_ving
staying114017323sta_ying
stetting93410713stetting
stiffing15248703stiffing
stifling122110903stifling
stilting93312393stilting
sting65330243s___ting
stinting93415743stinting
stotting92811153stotting
strafing122111193straf_ing
stuffing15247843stuffing
stunting92811503stunting
suiting83419003s_uiting
sulfating1338063sulfating
surfing112914483surf_ing
swabbing16246453swabbing
swagging14328093swagging
swaging124210633swa_ging
swamping16307923swamping
swanking16399963swanking
swanning12338813swanning
swapping16348673swapping
swarding1359003swarding
swarming1458223swarming
swashing15369743swashing
swathing15248713swathing
swaying143610643swa_ying
sweating123213023sweating
sweeting123911313sweeting
swotting12268473swotting
tarting84222653_tarting
tasting84624213_tasting
tatting84019523_tatting
tauting83316383_tauting
thacking183110043thacking
thanking16409523thanking
thawing14378683tha_wing
thwarting1632763thwarting
toasting93410573toasting
tufting11289873_tufting
unhatting1335873unhatting
unshifting1743863unshifting
upshifting1942343upshifting
upwafting1842063upwafting
vatting113614853_vatting
waffing173710243_waffing
waiting113618953_waiting
wanting114220173_wanting
wasting114422843_wasting
whacking21377483whacking
whaling143910773wha_ling
whamming19275223whamming
whanging16267143whanging
whapping19317113whapping
wharfing1834683wharfing
whetting1535973whetting
whiffing2134703whiffing
whisting15329543whisting
whiting143311303wh_iting
yaffing17337823_yaffing
yeasting12188923yeasting
zaftig1933253_zafti_g

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 Limit1461625077.89018525.0
3Display Results5075070.2032497.5
 (SQL Overall)1786915078.24921662.1
 
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.