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

136 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
shoveling163555(None) 
hoveling15189591_hoveling
shaveling1646841shaveling
shovelling1744061shovelling
groveling1435572groveling
hovelling1636162_hovelling
hovering151911142_hovering
shavelings1743502shavelings
shieling123512402sh_ieling
shivering1637332shivering
shoaling123111752sho_aling
shoeing113211882sho_e_ing
shooling123012562sho_oling
shoreline1246622shoreline
shoving142910642shov__ing
showering1646402showering
shriveling1743252shriveling
sniveling1336032sniveling
swiveling1634572swiveling
beveling143011033_beveling
boweling143410683_boweling
chiseling1536403chiseling
chortling1535563chortling
covering142215723_covering
coveting141912303_coveting
develing133212733_develing
disheveling19163093disheveling
dovening13238353_dovening
doweling13279763_doweling
driveling1445763driveling
gaveling133410163_gaveling
graveling1457383graveling
grovelling1554163grovelling
havening15258553_havening
havering152211053_havering
heeling113618513_h_eeling
hireling121210993_hireling
hobbling16227583_hobbling
hoeing104117023_ho_e_ing
holing104025073_ho__ling
homering141512073_homering
hondling132210013_hondling
honeying1537673_honeying
hoovering1635753hoovering
hoppling16206763_hoppling
hoseying1537193_hoseying
hosteling1337893_hosteling
houseling1337483_houseling
howling143413163_ho_wling
leveling122910433_leveling
marveling1537103marveling
modeling12311073_modeling
overing111918053__overing
phoneying1844283phoneying
raveling123414373_raveling
reveling123117083_reveling
roweling122811123_roweling
schooling1546943scho_oling
scowling1458293sco_wling
seeling83522003s__eeling
severing122013853s_evering
shackling19286173shackling
shambling1735593shambling
shauling1249393sh_auling
shaving143414333shav__ing
shawling1558223sh_awling
shealing123415463sh_ealing
shearling1336923shearling
sheening123010803sh_eening
sheering123715103sh_eering
sheeting122712833sh_eeting
shelling123515213sh_elling
shelving15278173sh__elving
shewing143812193sh__ewing
shielding1434553sh_ielding
shielings13237123sh_ielings
shilling123315383sh_illing
shingling14136973shingling
shocking184311543sho_cking
shogging14308023sho_gging
shooing112112913sho__oing
shooting122812863sho_oting
shopping163611293sho_pping
shorelines1346143shorelines
shoring112820073sho__ring
shortening1445303shortening
shorting122514803sho_rting
shotting123012383sho_tting
shouting122711793sho_uting
shovel124611323shovel___
shoveled15195353shovel_ed
shoveler14165583shovel_er
shovelers15174943shovelers
shovelful1882163shovelful
shovelled16174413shovelled
shoveller15174543shoveller
shovels13378393shovel__s
showing143814663sho__wing
showring1548323sho_wring
shrewing15228083sh_rewing
shrieking1734583shrieking
shrieving1633973shrieving
shrilling13307693shrilling
shrivelling1842213shrivelling
shuffling1933453shuffling
shuttling1334293shuttling
sideling101012183s_ideling
silvering1337923silvering
skoaling13227213sko_aling
slavering1338723slavering
slivering1338083slivering
snivelling1444293snivelling
snooling93013473sno_oling
snoozling19314343snoozling
snorkeling1542973snorkeling
sobering111912783s_obering
soiling83422323s_o_iling
soling74226823s_o__ling
speeling112713123s_peeling
spieling113212523s_pieling
spoiling112911553spo_iling
spooling113212563spo_oling
starveling1444263starveling
steeling93615143s_teeling
stooling93113133sto_oling
stoppling1474963stoppling
streeling10189483streeling
subvening1546033subvening
surveying1644963surveying
swivelling1743413swivelling
tholing112812333tho__ling
toweling122910373_toweling
traveling1349053traveling
troweling1376363troweling
wheeling15318593wh_eeling
yodeling1357673_yodeling

Search took 8 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.483369960.7
2DLD Change Limit1486411366.75022020.9
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.29624491.6
 
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.