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

251 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
shearling133692(None) 
shealing123415461shea_ling
shearing123915901shear_ing
shearlings1443531shearlings
healing113922962_hea_ling
hearing113324162_hear_ing
hearsing1239382_hearsing
hearting12513122_hearting
pearling11912012_pearling
sealing83528562s_ea_ling
searing83330922s_ear_ing
sharing113723242sh_ar_ing
sharking163912972sh_arking
sharping143011372sh_arping
shauling1249392sh_auling
shawling1558222sh_awling
sheafing15329482shea_fing
shealings13317562shea_lings
shearings13337562shear_ings
sheathing1636872sheathing
sheaving154110252shea_ving
sheering123715102sheer_ing
shelling123515212she_lling
shoaling123111752shoa_ling
smearing113511752smear_ing
snarling92513182s_narling
sparling112714532s_parling
spearing113216102spear_ing
starling93017122s_tarling
stealing93416602stea_ling
sterling93615552ste_rling
swearing123711442swear_ing
yearling1297882_yearling
anearing9413973anear_ing
ashlaring1344493ashlar_ing
bearding124011943_bearding
bearing103624773_bear_ing
blearing113111943blear_ing
carling103727063__carling
charging152910773ch_arging
charing133721323ch_ar_ing
charking183512613ch_arking
charming163012033ch_arming
charring142913163ch_arring
charting142614193ch_arting
cheating144014523chea_ting
cheering143612703cheer_ing
clearing113014883clear_ing
clearwing1533673clearwing
darling93418363__darling
dealing94323233_dea_ling
eagling91113603__eagling
eanling81416673__eanling
earing75235483__ear_ing
earning83418213__earning
earring83519013__earring
fearing113520033_fear_ing
gearing92818843_gear_ing
gheraoing1443523gheraoing
gnarling10217603_gnarling
hailing113820693_h_ailing
haling104229783_h_a_ling
haring104233003_h_ar_ing
harking154120943_h_arking
harming133717933_h_arming
harping134118383_h_arping
hauling113714433_h_auling
heading122919113_hea_ding
headline12129613_headline
headlong1334123_headlong
heaping133015853_hea_ping
hearings123611853_hear_ings
heating114024323_hea_ting
heaving144114763_hea_ving
heckling18257163_heckling
heeling113618513_he_eling
heiling113616363_he_iling
heiring113312903_heir_ing
helling114623223_he_lling
heralding1435773_heralding
herding122915123_he_rding
herring113615883_he_rring
herrying15147023_herrying
hoarding13288643_hoarding
hurling113616413_h_urling
impearling1543063impearling
learning978553_learning
marling103322763__marling
mishearing1647883mishear_ing
nearing83020333_near_ing
parling103823763__parling
pealing104123203_pea_ling
pharming16248143ph_arming
prearming14139223prearming
rearing83128783_rear_ing
rearming111413613_rearming
reearning1039053reearning
rehearing132211763rehear_ing
rehearsing1444343rehearsing
safariing1344553safariing
sailing83927373s__ailing
salarying1336073salarying
sapling103217863s__apling
scaling103519373s_ca_ling
scarfing14309713s_carfing
scaring103421973s_car_ing
scarping133312463s_carping
scarring112511513s_carring
scarting113415263s_carting
scheduling1742013scheduling
schmearing1842863schmear_ing
scrawling15195583scrawling
seagoing1038193s_eagoing
seaming103222113s_ea_ming
searching1538343s_earching
seating84130683s_ea_ting
seedling102610953s_eedling
seeling83522003s_e_eling
selling83225833s_e_lling
serging93416673s_e_rging
sering74731813s_e_r_ing
serrying12167693s_errying
serving113014983s_e_rving
settling978943s_ettling
shacking184014083sh_acking
shackling19286173shackling
shading123115563sh_a_ding
shafting15278683sh_afting
shagging14349053sh_agging
shaking153317253sh_a_king
shambling1735593shambling
shaming133016743sh_a_ming
shamming16289413sh_amming
shanking163612283sh_anking
shaping133116183sh_a_ping
shaveling1646843shaveling
shaving143414333sh_a_ving
shawing143514883sh_a_wing
sheaflike1942973sheaflike
shearlegs1342493shearlegs
sheathings1743913sheathings
shedding14278113she_dding
sheening123010803she_ening
sheeting122712833she_eting
shelving15278173she_lving
shending132511253she_nding
shewing143812193she__wing
shieling123512403sh_ieling
shikarring1881703shikarring
shilling123315383sh_illing
shingling14136973shingling
shirking163210473sh_irking
shirring122910443sh_irring
shirting123213613sh_irting
shooling123012563sh_ooling
shoring112820073sh_or_ing
shorting122514803sh_orting
shoveling1635553shoveling
showring1548323showr_ing
shrilling13307693shrilling
shuffling1933453shuffling
shuttling1334293shuttling
skirling13249063s_kirling
skoaling13227213skoa_ling
sleaving123310983slea_ving
smarting113212453s_marting
smelling113712723sme_lling
smerking15258473sme_rking
snailing92912973s_nailing
snarfing12358663s_narfing
snaring83920953s_nar_ing
sneaking133211093snea_king
sneaping11349493snea_ping
sneering93414503sneer_ing
snelling93913563sne_lling
soaring83521893s_oar_ing
spalling113213463s_palling
sparging122611133s_parging
sparing104823873s_par_ing
sparking152812543s_parking
sparkling16226353s_parkling
sparlings12257153s_parlings
sparring113112223s_parring
speaking153212493spea_king
speaning113512243spea_ning
spearlike1544143spearlike
spearmint1365983spearmint
speckling18235583speckling
speeling112713123spe_eling
speering113116323speer_ing
speiling113612973spe_iling
speiring113711263speir_ing
spelling113315233spe_lling
sphering142811943sphe_r_ing
spiraling1237953spiraling
sprawling15175123sprawling
squalling1935173squalling
squaring18158633squar_ing
squealing1935153squea_ling
stabling112913653s_tabling
staling83925423s_ta_ling
stalling95116703s_talling
stapling112813153s_tapling
staring84527053s_tar_ing
starlings10237923s_tarlings
starring92312953s_tarring
starting93116173s_tarting
startling1037373s_tartling
starving122510173s_tarving
steading103613593stea_ding
steadying14154503steadying
stealings10318853stea_lings
steaming114013213stea_ming
stearin7312003stear_in_
stearine8311903stear_ine
stearins8312143stear_ins
steeling93615143ste_eling
steering93916793steer_ing
sterlings10308753ste_rlings
stewarding1543523stewarding
sugaring1039053sugar_ing
swarding1359003s_warding
swarming1458223s_warming
sweating123213023swea_ting
swelling123212753swe_lling
swerving1546113swe_rving
swirling12249143s_wirling
tearing84021493_tear_ing
teazling1856573_teazling
thirling12248583th_irling
thralling13256833thralling
thwarting1632763thwarting
treadling1137503treadling
ushering1258923ushe_r_ing
vealing114217423_vea_ling
weakling16106763_weakling
weanling12118643_weanling
wearing113318863_wear_ing
wearying1546703_wearying
whaling143910773wh_a_ling
wharfing1834683wh_arfing
wheedling1733073wheedling
wheeling15318593whe_eling
wheepling1843323wheepling
wherrying1952993wherrying
whirling15237163wh_irling
yealing112716383_yea_ling
yeanling12107063_yeanling
yearlings1384203_yearlings
yearlong12102573_yearlong
yearning1296983_yearning

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412516.42023152.8
3Display Results2512510.0962614.6
 (SQL Overall)1786912516.93925751.7
 
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.