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

365 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
lagering10221231(None) 
laagering1136831laagering
layering122310351layering
wagering13219521wagering
ageing84213402_age_ing
algerine9810282algerine
altering91917112altering
angering102113802angering
badgering1436962badgering
cageling12310842cageling
capering132414962capering
catering112019902catering
clavering1538372clavering
daggering13246112daggering
dangering12239302dangering
havering152211052havering
labeling11311642labeling
laboring112110142laboring
lacewing1435842lacewing
lackering1639372lackering
laddering1237592laddering
ladening1078822ladening
lagging103316732lag_ging
lairing83715342la_iring
lappering14258842lappering
latening9711492latening
lathering13912252lathering
laveering1336812laveering
lawyering1655212lawyering
layerings13235682layerings
leaguering1243812leaguering
leering83417642l_eering
levering122212502levering
lingering11310512lingering
livering122012382livering
lowering122210912lowering
lugeing9359112luge_ing
papering132213312papering
rogering10310272rogering
sabering112113742sabering
saggering12197792saggering
slavering1338722slavering
tabering112211422tabering
tapering112112502tapering
wafering15208892wafering
watering122316312watering
wavering152410542wavering
adhering1338883adhering
adoring9412523_adoring
ageings9437693_age_ings
agelong934983_agelong
agenting1039383_agenting
aging77026353_ag__ing
agreeing10295903_agreeing
airing74927503_a_iring
alerting91312383_alerting
algerines1069083algerines
aliening91510893aliening
alleging1038473alleging
alluring939073alluring
amercing1337193_amercing
anearing9413973_anearing
aneling82719503_aneling
angeling102811733angeling
auguring1036383auguring
averring12239063_averring
averting122512733_averting
aweing103911253_awe_ing
bagging123316983bag_ging
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
baring95135853ba__ring
barring104021593ba_rring
bartering122313643bartering
battering122715143battering
beavering1538703beavering
blabbering14104363blabbering
blagging13319163blag_ging
blaring104317113bla__ring
blathering16107583blathering
blattering13108713blattering
bogeying1575703bogeying
bowering142911713bowering
buggering1435193buggering
cagelings1335413cagelings
caging105321023cag__ing
cambering16109873cambering
cameoing1379063cameoing
cankering162110793cankering
cantering122417373cantering
careering12311203careering
caring95137993ca__ring
caverning1536283caverning
cering94522533__cering
cheering143612703cheering
clabbering17104583clabbering
clagging13328873clag_ging
clambering1776163clambering
clamoring1477423clamoring
clangoring1443913clangoring
clattering13109233clattering
cohering142413833cohering
covering142215723covering
cowering142514033cowering
cratering12312653cratering
dackering1737383dackering
daggling12237063daggling
daikering1536103daikering
dandering122511063dandering
daring84928683da__ring
davening13258873davening
degerming1435753degerming
diapering1339033diapering
dogearing1235763dogearing
dowering132510613dowering
eagling91113603eag_ling
earing75235483ea__ring
earring83519013ea_rring
elaterin849903elaterin_
elaterins9410033elaterins
entering91920053entering
faceting1438783faceting
fagging133714763fag_ging
fagoting1336283fagoting
fairing113614013fa_iring
faltering132211113faltering
faring105231283fa__ring
fathering161010093fathering
favoring1596673favoring
fevering152510083fevering
figuring1336283figuring
fingering1439193fingering
flagging14329223flag_ging
flaring114116803fla__ring
flattering1498743flattering
flavoring1665113flavoring
fleering123811283fleering
flowering1636053flowering
gaeing84617223ga_e_ing
gagging93013523gag_ging
gaggling10217463gaggling
gaging94718403gag__ing
gandering122111293gandering
garnering11298083garnering
garring93116713ga_rring
gartering112111573gartering
gathering1499463gathering
gaveling133410163gaveling
gearing92818843__gearing
geeing84313773__geeing
gingering1238873gingering
glaceing1236533glace_ing
glairing1047283gla_iring
glaring93714883gla__ring
glowering1435653glowering
goring84119573__goring
gyring113910363__gyring
haeing104118923ha_e_ing
hagging133114683hag_ging
haggling14227273haggling
haltering132212003haltering
hammering1737633hammering
hampering1738863hampering
hangaring1438033hangaring
hankering17239383hankering
haring104233003ha__ring
havening15258553havening
homering141512073homering
hovering151911143hovering
hungering14187683hungering
inhering12913713inhering
jabbering2134443jabbering
jagging173311993jag_ging
jarring153613193ja_rring
jeering153513043_jeering
jiggering1934303jiggering
kashering1736253kashering
labelling1238083labelling
labouring1236213labouring
lacerating1349443lacerating
lacewings1543303lacewings
lacing94626233la__cing
lackeying1934923lackeying
lacking143821543la_cking
lacquering2243603lacquering
lading84227123la__ding
ladling92813393la_dling
lagend838743lage__nd
lager65132863lager___
lagered92311153lager_ed
lagers74826143lager__s
laggings11298403lag_gings
laking115027043la__king
lalling83519623la_lling
lambing123412413la_mbing
lamenting1237693lamenting
laming94528363la__ming
lamming123014583la_mming
lamping123116003la_mping
lancing103314123la_ncing
landing92819323la_nding
lapping124117023la_pping
lapsing103511163la_psing
lapwing13308263la_pwing
larding92917873la_rding
larine63927043la__rine
larking123718253la_rking
lashing114422893la_shing
lasing74727983la__sing
lassoing946383lassoing
lasting84725243la_sting
latching143712023latching
lateraling11148803lateraling
laterite8716333laterite
laterize17613293laterize
laterizing2049093laterizing
lathing114315693la_thing
latrine7715123la_trine
lauding93211903la_uding
laughing1335933laughing
laundering1245183laundering
laureling1035643laureling
laving104623573la__ving
lawgiving1762143lawgiving
lawing104625283la__wing
lawyerings1752583lawyerings
laying104525703la__ying
lazing164821473la__zing
lazying2046673la_zying
leadening1176733leadening
leaguing1035343leag_uing
leathering1488683leathering
leavening1365973leavening
lechering1538443lechering
legating102313113legating
legerity1245713legerity
legging103912643leg_ging
lettering102112073lettering
leveeing12265963leveeing
leveling122910433leveling
libeling1139873libeling
ligating102212283ligating
lightering15246113lightering
lighting132811833lighting
likening13246893likening
limbering1488793limbering
lippering14217883lippering
littering102411983littering
livening12248153livening
logging103316803log_ging
loitering1039683loitering
longeing10177593longe_ing
loppering14237283loppering
louring83916503l_ouring
lugging104114353lug_ging
luging83915293lug__ing
lumbering14117933lumbering
luring73820753l__uring
lustering102711203lustering
lustring9269723lustring
majoring1836363majoring
mammering1337333mammering
manuring1139223manuring
marring103319553ma_rring
mastering122315303mastering
mattering122314053mattering
maturing1139953maturing
metering112915633metering
mitering113015403mitering
mongering13310353mongering
nagging102613043nag_ging
nattering102212213nattering
nidering10510483nidering
oaring74225303oa__ring
ochering14219393ochering
offering1536393offering
ordering1039353ordering
overing111918053_overing
paging104020403pag__ing
pairing103716733pa_iring
palavering1644483palavering
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
paneling111013623paneling
pargeting1338283pargeting
paring94236493pa__ring
parring103222063pa_rring
pattering122314423pattering
paupering1437273paupering
peering103520353_peering
petering112516813petering
plaguing1236033plag_uing
plastering1339243plastering
powering142210803powering
quavering2235953quavering
queering1838203queering
ragging103516683rag_ging
raging85126433rag__ing
raring74332873ra__ring
raveling123414373raveling
ravening122611293ravening
razeeing1834363razeeing
razoring1836443razoring
regearing112211413regearing
revering122918073revering
sabeing102611863sabe_ing
sabring102614843sa_bring
sacring103115983sa_cring
saggaring12236243saggaring
sagging103116103sag_ging
savoring1269483savoring
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
slabbering15104973slabbering
slagging113711573slag_ging
slandering1237243slandering
slathering14108283slathering
slivering1338083slivering
sneering93414503sneering
sobering111912783sobering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
staggering13194583staggering
steering93916793steering
sugaring1039053sugaring
supering11317683supering
swaggering16233623swaggering
taboring113010193taboring
tagging103014913tag_ging
tampering1438453tampering
tangerine1048403tangerine
targeting1137303targeting
taring73932283ta__ring
tarring83318303ta_rring
tattering102212323tattering
tiering8315253_tiering
towering122610873towering
ulcering1139333ulcering
umbering1399433umbering
unageing1036273unage_ing
ushering1258923ushering
uttering91613083uttering
valeting1238843valeting
vaporing1437653vaporing
veering113213683_veering
wagging133313353wag_ging
waggling14197063waggling
waging114318383wag__ing
wagoning1336923wagoning
wairing113414313wa_iring
waitering13310713waitering
wakening1636323wakening
wandering143310983wandering
waring105029443wa__ring
warring113717973wa_rring
waterings13229253waterings
yabbering1734023yabbering
yammering1735193yammering
yattering132410443yattering
zagging193210453zag_ging

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623657.22020244.0
3Display Results3653650.1562339.7
 (SQL Overall)1786913657.79622920.9
 
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.