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

459 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
settling97894(None) 
fettling1266771fettling
nettling957211nettling
pettling1168211pettling
setting83621391sett_ing
settlings1054681settlings
battling113110492battling
beetling1139282beetling
betting103921402bett_ing
bottling11279142bottling
cuttling1138202cuttling
fetting113517872fett_ing
fettlings1353752fettlings
gentling1048452gentling
getting93316562gett_ing
guttling1037292guttling
jetting153815342jett_ing
jettying1933952jettying
kittling1336062kittling
letting83218532lett_ing
metaling111613722metaling
mottling11197752mottling
nestling958892nestling
netting84018762nett_ing
pestling111010252pestling
petting103720952pett_ing
rattling92510872rattling
resettling1135892resettling
retiling93319482retiling
retitling1039772retitling
retting83425882rett_ing
scuttling1234242scuttling
sealing83528562se_aling
seating84130682seat_ing
seedling102610952seedling
seeling83522002se_eling
seething1239022seething
selling83225832se_lling
setline7313922se_tline
settings93810072sett_ings
shuttling1334292shuttling
sitting83519632sitt_ing
staling83925422s_taling
stealing93416602stealing
steeling93615142steeling
sterling93615552sterling
stetting93410712stetting
styling112910652s_tyling
tattling9259472tattling
unsettling1144432unsettling
vetting114216562vett_ing
vittling1236142vittling
wattling12258782wattling
wetting114117382wett_ing
abetting1158293abett_ing
bantling112612003bantling
batting104422273batt_ing
beating104326873beat_ing
belittling1343193belittling
belling103825073be_lling
belting104119133belt_ing
beltline1036943beltline
berthing14209603berthing
besetting12268423besett_ing
besting104923923best_ing
betaking153010153betaking
betiding1239913betiding
bettering122212753bettering
beveling143011033beveling
bitting103717293bitt_ing
bottlings12215293bottlings
brattling1236003brattling
brittling1235543brittling
bustling112110063bustling
butling103516813_butling
butting103519283butt_ing
castling11311233castling
catling104819793_catling
catting103922643catt_ing
ceiling103416723ce_iling
celling103921263ce_lling
centring112112953centring
chitling142910663chitling
cuittling1234103cuittling
cutting103817493cutt_ing
dartling1039563dartling
dealing94323233de_aling
defiling132812463defiling
denting94422183dent_ing
detailing112510413detailing
detoxing1736313detoxing
develing133212733develing
deviling1311812853deviling
dittoing1036263dittoing
dotting93314483dott_ing
duetting1047183duett_ing
eagling91113603_eagling
eanling81416673_eanling
eating75134403_eat_ing
entitling1037103entitling
estating92614993estating
etching134511843_etching
exiling15311083_exiling
fatling113815683_fatling
fatting113818703fatt_ing
feeling113617073fe_eling
felling113321133fe_lling
felting113515213felt_ing
feruling1258873feruling
fetching17298413fetching
feting104417793fe_t_ing
fettering132310513fettering
fitting113516563fitt_ing
flatling123410013flatling
footling12239923footling
fretting122711523frett_ing
gelling93219763ge_lling
gettering112310033gettering
ghettoing1442123ghettoing
gitting93215703gitt_ing
gutting93415923gutt_ing
hatting113920233hatt_ing
healing113922963he_aling
heating114024323heat_ing
heckling18257163heckling
heeling113618513he_eling
hefting144510913heft_ing
heiling113616363he_iling
helling114623223he_lling
henting113719653hent_ing
hitting113017273hitt_ing
hotting113116523hott_ing
hurtling12318313hurtling
hustling12228793hustling
hutting113016033hutt_ing
insetting1079283insett_ing
intitling1037213intitling
jelling153516613je_lling
jesting154317713jest_ing
jeweling1935483jeweling
jostling16207123jostling
jotting152912773jott_ing
justling16207253justling
jutting153313713jutt_ing
juttying1933573juttying
keckling14245523keckling
keeling123515123ke_eling
kegling13309363ke_gling
kitling123313573_kitling
kitting123214443kitt_ing
leftwing1532973leftwing
letching143810263letching
lettering102112073lettering
leveling122910433leveling
lotting82917753lott_ing
mantling112012613mantling
matting103620143matt_ing
medaling121912263medaling
meddling13257933meddling
meeting103314963meet_ing
melling102822623me_lling
melting103317753melt_ing
metalling1249593metalling
metering112915633metering
meting94320593me_t_ing
metring103215293me_tring
mewling13329513me_wling
needling10248753needling
nesting84320443nest_ing
nestlings1074313nestlings
nettings9288103nett_ings
nettlier864813nettlier
nutting83316233nutt_ing
patting103722343patt_ing
pealing104123203pe_aling
pearling11912013pearling
pebbling1535073pebbling
pedaling122412133pedaling
peddling13217973peddling
peeling102919873pe_eling
pelting102917273pelt_ing
peopling1338353peopling
periling11316863periling
petaline10314883petaline
petering112516813petering
pettings11349703pett_ings
pitting103618873pitt_ing
potting103720893pott_ing
prattling1246303prattling
presettling1444453presettling
prettying1536043prettying
putting103218573putt_ing
puttying1434953puttying
ratting83822363ratt_ing
rattlings10235513rattlings
rebottling1343733rebottling
reddling112911813reddling
reedling102414273reedling
reeling83126863re_eling
refiling123116533refiling
regaling10315363regaling
renting84026853rent_ing
reoiling93217213reoiling
resetting102816293resett_ing
resiling93520173resiling
resoling92916303resoling
resting85031183rest_ing
restring91518783restring
restyling1337923restyling
retailing103214733retailing
retaking133114283retaking
retaping113012553retaping
retaxing162311333retaxing
retching143412173retching
retelling102112493retelling
retieing92913713retieing
retiming113014193retiming
retiring92717413retiring
retooling1039093retooling
retotaling1186883retotaling
retrying122410453retrying
retuning9311583retuning
retying113213833re_tying
retyping14255613retyping
reveling123117083reveling
reviling122917213reviling
rootling9269953rootling
rotting82919683rott_ing
rustling9249983rustling
rutting82718043rutt_ing
saddling11239593saddling
sailing83927373s_ailing
salting84120793salt_ing
sampling13510643sampling
sandling102214413sandling
sapling103217863s_apling
sating74735453s_at_ing
sauteing937913sauteing
scaling103519373s_caling
scantling12107233scantling
scathing14269703scathing
scatting113311813scatting
scenting113212813scent_ing
sceptring1444273sceptring
scowling1458293scowling
sculling112910993sculling
scything17264883scything
seagoing1038193seagoing
seaming103222113se_aming
searing83330923se_aring
seatings93614303seat_ings
seceding12288563seceding
sectoring1239583sectoring
securing11310413securing
sedating103014113sedating
seducing1236503seducing
seeding93719483se_eding
seedlings11195953seedlings
seeing74222143se__eing
seeking124016063se_eking
seeming103216263se_eming
seeping103817913se_eping
segueing1034983segueing
seining84020773se_ining
seising84018863se_ising
seizing174114833se_izing
selfing112911623se_lfing
semolina1047493semolina
sending94221373se_nding
sensing84116953se_nsing
sepaline10311343sepaline
septupling1542363septupling
serging93416673se_rging
sering74731813se__ring
serrying12167703serrying
serving113014983se_rving
sestina72711973sest_ina
sestine73017923sest_ine
setlines8312743se_tlines
settle63915663settl__e
settled83210873settl_ed
settler73410653settl_er
settlers8289023settlers
settles73916003settl_es
settlor7314733settl_or
settlors8255013settlors
severing122013853severing
sewering122411093sewering
sewing103819623se__wing
sexing144313893se__xing
sextain14257103sextain_
sextains15246813sextains
sextupling2042153sextupling
shauling1249393shauling
shawling1558223shawling
shealing123415463shealing
shearling1336923shearling
sheathing1636873sheathing
sheeting122712833sheet_ing
shelling123515213shelling
shieling123512403shieling
shilling123315383shilling
shitting123212663shitting
shoaling123111753shoaling
shooling123012563shooling
shotting123012383shotting
shuting113212053shut_ing
shutting12309693shutting
sibling10814423s_ibling
sickling152910333sickling
sideling101012183sideling
sidling9915423s_idling
sifting113014593sift_ing
silting83320483silt_ing
singling101913003singling
siting74126623s_it_ing
sittings9339733sitt_ings
sizzling17225783sizzling
skating123613853skat_ing
sketching1935083sketching
skilling132911333skilling
skirling13249063skirling
skiting123812503skit_ing
skoaling13227213skoaling
skulling13258103skulling
slating83724653slat_ing
slatting94014233slatting
sleeting93114163sleet_ing
sleuthing1334203sleuthing
sling66028803s___ling
slitting93012583slitting
slotting92612613slotting
smelling113712723smelling
smelting11339713smelt_ing
smiling103915443s_miling
smiting103014443smit_ing
smutting11278063smutting
snailing92912973snailing
snarling92513183snarling
snelling93913563snelling
snooling93013473snooling
soiling83422323s_oiling
soling74226823s__oling
soothing12269973soothing
sooting82820963soot_ing
sorting83221813sort_ing
southing122811823southing
spalling113213463spalling
sparling112714533sparling
spatting113111763spatting
speckling18235583speckling
speeling112713123speeling
speiling113612973speiling
spelling113315233spelling
spieling113212523spieling
spiling102919703s_piling
spilling113113943spilling
spiting103917623spit_ing
spitting113012323spitting
spoiling112911553spoiling
spooling113212563spooling
spotting112812093spotting
sprattling1363053sprattling
stabling112913653stabling
staging93818373s_taging
staking123919803s_taking
stalking133512223s_talking
stalling95116703stalling
staning83922243s_taning
stapling112813153stapling
staring84527053s_taring
starling93017123starling
startling1037373startling
stating83725163s_tating
staving113915703s_taving
staying114017323s_taying
steading103613593steading
stealings10318853stealings
steaming114013213steaming
steeking133411353steeking
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemming13408203stemming
stepping13329073stepping
sterlings10308753sterlings
stewing113412493s_tewing
stifling122110913stifling
stilling93415323stilling
stilting93312403s_tilting
sting65330243s__t_ing
stoking123615593s_toking
stoning83717443s_toning
stooling93113133stooling
stoping103716623s_toping
storing83921123s_toring
stotting92811163stotting
stowing113315133s_towing
string75327563s__tring
stying105414573s__tying
stylings12276233s_tylings
subtitling1344563subtitling
suckling152410023suckling
suiting83419003suit_ing
suppling1359043suppling
suturing9310373suturing
swathing15248713swathing
swatting12309593swatting
sweating123213023sweat_ing
sweeting123911313sweet_ing
swelling123212753swelling
sweptwing1841693sweptwing
swilling123511933swilling
swirling12249143swirling
swotting12268483swotting
tatting84019523tatt_ing
teazling1856573teazling
teething1237163teething
telling83321083te_lling
tenting84621153tent_ing
testing86021053test_ing
tiling73426553__tiling
titling83715793_titling
toling73926123__toling
tootling9279523tootling
totaling9610303totaling
totting82816843tott_ing
turtling9238833turtling
tutting83515913tutt_ing
twattling1332693twattling
unsetting1088993unsett_ing
upsetting1275563upsett_ing
vatting113614853vatt_ing
vealing114217423ve_aling
veiling113615293ve_iling
venting114218093vent_ing
vesting114618683vest_ing
vetchling1843593vetchling
vetoing11309053ve_toing
weakling16106763weakling
weanling12118643weanling
wedeling1338773wedeling
weeting113816053weet_ing
welling112920313we_lling
welting113615313welt_ing
westing115020273west_ing
wettings12348403wett_ings
whetting1535973whett_ing
whittling1634383whittling
wintling12249923wintling
witling113215813_witling
witting113417063witt_ing
wotting112913843wott_ing
wrestling1336063wrestling
yealing112716383ye_aling
yeanling12107063yeanling
yearling1297883yearling
yelling113516703ye_lling
zesting174515333zest_ing

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.420425454.8
2DLD Change Limit1461624598.11018022.4
3Display Results4594590.1862467.7
 (SQL Overall)1786914598.71620501.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.