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

399 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
skoaling1322721(None) 
shoaling123111751shoaling
coaling103722822_coaling
foaling113515842_foaling
goaling93515332_goaling
scaling103519372s_caling
scowling1458292scowling
sealing83528562s_ealing
shealing123415462shealing
shooling123012562shooling
skating123613852sk_ating
skilling132911332skilling
skirling13249062skirling
skulling13258102skulling
snooling93013472snooling
soaking123116612s_oaking
soaping103616222s_oaping
soaring83521892s_oaring
soiling83422322s_oiling
soling74226822s_o_ling
spoiling112911552spoiling
spooling113212562spooling
staling83925422s_taling
stealing93416602stealing
stooling93113132stooling
assoiling1045353assoiling
baling94829693__baling
bloating113512813bloating
boating103721303_boating
boiling103819673_boiling
bolling103820883_bolling
boodling121910243boodling
bowling133916493_bowling
broiling113112013broiling
canaling112016413canaling
cloaking15299713cloaking
coaming123818323_coaming
coating103525313_coating
coaxing173511703_coaxing
codling114418953_codling
coiling103723453_coiling
cooling103422573_cooling
cowling134017423_cowling
craaling112711353craaling
croaking153712163croaking
dealing94323233_dealing
dialing94318173_dialing
doating93816863_doating
doling84923133_do_ling
dolling93817373_dolling
doodling11218403doodling
drolling103510763drolling
drooling102610423drooling
empaling1338363empaling
equaling1837793equaling
exhaling1936293exhaling
floating123111883floating
foaming133612993_foaming
foiling113317653_foiling
fooling113117373_fooling
footling12239923footling
foozling21275723foozling
fouling113315373_fouling
fowling143713113_fowling
gaoling93314653gao_ling
gloaming12268013gloaming
gloating102611463gloating
goading103112853_goading
godling103513403_godling
gosling93312403_gosling
groaning102410283groaning
growling1348163growling
haling104229783__haling
healing113922963_healing
hoaxing18307763_hoaxing
holing104025073_ho_ling
howling143413163_howling
impaling1338253impaling
inhaling1239523inhaling
kalong1177703_k_along
kaoliang1341823_kaoliang
kaolin1039583_kaolin_
kaoline11310143_kaoline
kaolins1139363_kaolins
keeling123515123_keeling
kegling13309363_kegling
killing123118723_killing
kitling123313573_kitling
knolling13206893knolling
konking113510213_konking
kraaling13186663kraaling
loading94114613_loading
loafing11319793_loafing
loaming103613733_loaming
loaning83614833_loaning
lolling83415783_lolling
medaling121912263medaling
metaling111613723metaling
moaning103714443_moaning
moating104218153_moating
moiling103417663_moiling
noodling10209443noodling
oaring74225303__oaring
ogling83211883__ogling
oiling74925313__oiling
okaying1534833ok_aying
paling93530133__paling
pealing104123203_pealing
pedaling122412133pedaling
peopling1338353peopling
poling93526503_po_ling
polling102920383_polling
pooling103219093_pooling
prowling1449993prowling
recoaling121312453recoaling
regaling10315363regaling
reoiling93217213reoiling
rivaling1239913rivaling
roaming103215793_roaming
roaring82916003_roaring
roiling83220453_roiling
rolling83620413_rolling
rootling9269953rootling
saddling11239593saddling
sailing83927373s_ailing
salina64221123s__alina
saline65132703s__aline
salting84120793s__alting
salving113913153s__alving
sampling13510643sampling
sandaling112010563sandaling
sandling102214413sandling
saning75127643s__aning
sapling103217863s_apling
sating74735453s__ating
savaging1356673savaging
saving104724513s__aving
sawing104323813s__awing
saying104325543s__aying
scalding12339393s_calding
scalping133410453s_calping
scaping123715693s_caping
scaring103421973s_caring
schooling1546943schooling
scoffing17275943scoffing
scolding12278913scolding
sconcing1338263sconcing
scooping133610633scooping
scooting113012643scooting
scoping123513823sco_ping
scoring103117213sco_ring
scorning1169133scorning
scouring112810853scouring
scouting112612753scouting
scowing133812093sco_wing
scraping133310863scraping
scrawling15195583scrawling
scrolling12187803scrolling
sculling112910993sculling
seaming103222113s_eaming
searing83330923s_earing
seating84130683s_eating
sedating103014113sedating
seedling102610953seedling
seeling83522003s_eeling
selling83225833s_elling
sepaline10311343sepaline
settling978943settling
shading123115563s_hading
shaking153317253s_haking
shaming133016743s_haming
shaping133116183s_haping
sharing113723243s_haring
shauling1249393shauling
shaving143414333s_having
shawing143514883s_hawing
shawling1558223shawling
sheafing15329483sheafing
shealings13317563shealings
shearing123915903shearing
shearling1336923shearling
sheaving154110253sheaving
shelling123515213shelling
shieling123512403shieling
shilling123315383shilling
shoalier1137073shoalier
shocking184311543shocking
shoeing113211883sho_eing
shogging14308023shogging
shooing112112913sho_oing
shooting122812863shooting
shopping163611293shopping
shoring112820073sho_ring
shorting122514803shorting
shotting123012383shotting
shouting122711793shouting
shoveling1635553shoveling
shoving142910643sho_ving
showing143814663sho_wing
showring1548323showring
sibling10814423s_ibling
sickling152910333sickling
sideling101012183sideling
sidling9915423s_idling
signaling1136563signaling
singling101913003singling
sizzling17225783sizzling
skanking12288743skanking
skatings13326993sk_atings
skeeing12308853sk_eeing
skeining1347073skeining
skelping1535973skelping
skewing15318723sk_ewing
skidding1535463skidding
skiffling2043103skiffling
skiing113610193sk__iing
skillings14246133skillings
skimming17286273skimming
skimping17306243skimping
skinking12299773skinking
skinning13327893skinning
skioring13237223skioring
skipping17297603skipping
skirring13297143skirring
skirting13289393skirting
skiting123812503sk_iting
skiving15298373sk_iving
skoal93811463skoal___
skoaled12226063skoal_ed
skoals10438243skoal__s
skulking12245903skulking
skunking12256653skunking
skying14399983sk__ying
skyline1436793sk_yline
slaking123717473s_laking
slating83724653s_lating
slaving113514833s_laving
slaying113316843s_laying
sleaving123310983sleaving
sling66028803s___ling
slogging113410493slogging
sloping104114073slo_ping
slopping133811423slopping
sloshing12258823sloshing
slotting92612613slotting
slowing112814743slo_wing
smearing113511753smearing
smelling113712733smelling
smiling103915443s_miling
smocking17349103smocking
smoking143210523smo_king
snailing92912973snailing
snaking123915303s_naking
snaring83920953s_naring
snarling92513183snarling
snawing113612483s_nawing
sneaking133211093sneaking
sneaping11349493sneaping
snelling93913563snelling
snogging11318043snogging
snooding102910433snooding
snooking133010583snooking
snooping113811323snooping
snooting92813203snooting
snoozing18319083snoozing
snoozling19314343snoozling
snoring83917203sno_ring
snorting92613373snorting
snouting92511923snouting
snowing113913453sno_wing
soarings93210393s_oarings
sobbing127612883s_obbing
socking143518603s_ocking
sodding103712733s_odding
solacing11310133solacing
solating9315593solating
soloing82813803s_oloing
solving112910853s_olving
soothing12269973soothing
sooting82820963s_ooting
sopping123917203s_opping
sorbing102815263s_orbing
soring74731883s_o_ring
sorning83116813s_orning
sorting83221813s_orting
souping104215533s_ouping
souring83219063s_ouring
sousing83517823s_ousing
sowing104222913s_o_wing
spacing123614493s_pacing
spading113114383s_pading
spaeing103413543s_paeing
spalling113213463spalling
sparing104823873s_paring
sparling112714533sparling
spaying133014623s_paying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
speeling112713123speeling
speiling113612973speiling
spelling113315233spelling
spieling113212523spieling
spiling102919703s_piling
spilling113113943spilling
spiraling1237953spiraling
splaying14219303splaying
spoking143212223spo_king
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spoolings12245393spoolings
spooning112811443spooning
spooring113111463spooring
sporing104319413spo_ring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
sprawling15175123sprawling
spraying14299883spraying
squalling1935173squalling
squaring18158633squaring
squealing1935153squealing
stabling112913653stabling
staging93818373s_taging
staking123919803s_taking
stalking133512223s_talking
stalling95116703stalling
staning83922243s_taning
stapling112813153stapling
staring84527053s_taring
starling93017123starling
stating83725163s_tating
staving113915703s_taving
staying114017323s_taying
steading103613593steading
stealings10318853stealings
steaming114013213steaming
steeling93615143steeling
sterling93615553sterling
stifling122110913stifling
stilling93415323stilling
stobbing13227243stobbing
stocking152912503stocking
stodging11277463stodging
stoking123615593sto_king
stomping13309763stomping
stoning83717443sto_ning
stooging102810043stooging
stooking132711143stooking
stooping113012363stooping
stoping103716623sto_ping
stopping133611413stopping
stoppling1474963stoppling
storing83921123sto_ring
storming11209423storming
storying12249673storying
stotting92811163stotting
stowing113315133sto_wing
strafing122111193strafing
strawing122411623strawing
straying122912693straying
strolling10238793strolling
styling112910653s_tyling
suckling152410023suckling
sugaring1039053sugaring
suppling1359043suppling
swaging124210633s_waging
swaying143610643s_waying
swearing123711443swearing
sweating123213023sweating
swelling123212753swelling
swilling123511933swilling
swirling12249143swirling
swobbing16235173swobbing
swooning12278203swooning
swooping14338403swooping
swopping16377963swopping
swotting12268483swotting
swouning12246563swouning
tholing112812333tho_ling
toiling83219023_toiling
toling73926123_to_ling
tolling83418563_tolling
tooling82918313_tooling
tootling9279523tootling
totaling9610303totaling
troaking133310973troaking
trolling93212493trolling
unbaling11310683unbaling
vealing114217423_vealing
vialing113614163_vialing
voling103918023_vo_ling
waling104525303__waling
whaling143910773_whaling
yealing112716383_yealing
yodling123610253_yodling
yowling143610223_yowling

Search took 7 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.423422437.4
2DLD Change Limit1461623996.37322934.6
3Display Results3993990.1562557.7
 (SQL Overall)1786913996.95225703.5
 
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.